MySQL常见的求交集、并集和差集

1、select  a.*,b.*  from tableA a left join tableB b on a.key = b.key;

2、select  a.*,b.*  from tableA a right join tableB b on a.key = b.key; 

3、select  a.*,b.*  from tableA a inner join tableB b on a.key = b.key; 

4、select  a.*,b.*  from tableA a left join tableB b on a.key = b.key where b.key is null; 

5、select  a.*,b.*  from tableA a left join tableB b on a.key = b.key where a.key is null; 

6、select  a.*,b.*  from tableA a full outer join tableB b on a.key = b.key; 

7、select  a.*,b.*  from tableA a full outer join tableB b on a.key = b.key where a.key is null or b.key is null;