SQL join

1 左连接

Select * from A Left Join B On A.id= B.id

2 右连接

Select * from A Right Join B On A.id = B.id

3 内连接

Select * from A Inner Join B On A.id = B.id

4 左独有

Select * from A Left Join B On A.id = B.id where B.id is NULL

5 右独有

Select * from A Right Join B On A.id = B.id where A.id is NULL

6 全连接

Select * from A Full Join B On A.id = B.id  (mysql不支持)
或
select * from A left join B on A.id = B.id
union 
select * from A right join B on A.id = B.id;

7 左+右去掉交集

select * from A left join B on A.id = B.id where B.id is Null
union 
select * from A right join B on A.id = B.id where A.id is Null;