SQL中连接JOIN语句可以分为:
1,内部连接inner join,仅返回表A和表B中连接列匹配的那些行:
select * from A inner join B on A.k=B.k;
2,外部连接outer join,返回表A和表B中连接列匹配和不匹配的那些行,还能返回表A和表B中连接列为NULL的那些行:
select * from A outer join B on A.k=B.k;
3,左连接left join和右连接right join,都属于外部连接类型,返回类型与外连接类似:
select * from A left join B on A.k=B.k;
select * from A right join B on A.k=B.k;