1. 常见的四种join的区别
常见的join主要有下面四种,join,outer join, semi join和inner join,下面对这四个join的关系进行说明
(1.1)join等价于inner join,也就是只会将两表都存在的join在一起
(1.2)outer join分为:
left outer join(等价于left join),right outer join(right join)和full outer join(full join)
Left join是以左表为基准,右表不存在的key均赋值为null
Right join是以右表为基准,左表不存在的key均赋值为null
Full join是取出现在左右两表的key的并集,某张表里面不存在的key赋值为null
(1.3)semi join:semi join只有left semi join,不存在semi join 和 right semi join
left semi join跟join的逻辑是一样的,但是有着三点不同
综上所述:join语句其实只有五种:join(inner join)、left join(left outer join)、right join(right outer join)、full join(full outer join)、left semi join
2. 对于各种j