My sql 多表连接查询

1.隐式内连接
select * from A,B where A.id=B.id
2.显示内连接
select * from A inner join B on A.id=B.id

3.左外连
select * from A left join B on A.id=B.id

4.右外连
select * from A right 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 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

7.全连
select * from A left join B on A.id=B.id
union
select * from A right join B on A.id=B.id

8.笛卡尔积
select * from A cross join B
cross join：交叉连接，得到的结果是两个表的乘积，即笛卡尔积

示例：