1.内连接(内连接查询的是两张表的交集,也就是A表和B表都必须有数据才能查询出来(join和on是一起的)
select * from A join B on A.id = B.id
select * from A inner join B on A.id = B.id
select * from A,B where A.id = B.id
2.左外连接和右外连接
左连接(查询A表中的所有数据并且满足条件的B中的数据)
select * from A left join B on A.id = B.id
select * from A left outer join B on A.id = B.id
右连接(查询B表中所有数据并且满足A中的数据)
select * from B left join A on A.id = B.id
select * from B left outer join A on A.id = B.id
3.全连接 (查询AB当中的所有数据及满足ON后的条件后的数据)由于Mysql中没有full join,只有oracle中才
有,所有采用union进行全连接
select * from a left join b on a.id = b.id
union
select * from a right join b on a.id = b.id