外连接
外连接分为外左连接(left outer join)和外右连接(right outer join)
left outer join 与 left join 等价, 一般写成left join
right outer join 与 right join等价, 一般写成right join
左连接:左侧+交集部分
语法:
select <select list> from A left join B on A.id=B.id
右连接:右侧+交集
语法:
select <select list> from A right join B on A.id=B.id
内连接(inner join)
内连接:也称为等值连接,返回两张表都满足条件的部分
语法:
select * from a INNER JOIN b on a.a = b.b;
select a.*, b.* from a,b where a.a = b.b;
全连接:a+b表所有元素
select * from a FULL OUTER JOIN b on a.a = b.b;