目录
1、inner join
select * from Table A inner join Table B on Table A.id=Table B.id
inner join on = join on
join on 和 where 效率一样(无索引)
2、Left join
select * from Table A left join Table B on Table A.id=Table B.id
oracle的左连接另外一种表达方式
select * from Table A, Table B where A.id = B.id(+)
同理右连接
select * from Table A, Table B where A.id(+) = B.id
LEFT JOIN返回左表的全部行和右表满足ON条件的行,如果左表的行在右表中没有匹配,那么这一行右表中对应数据用NULL代替。
left join on = left outer join on,没有left inner join on,right join 类似
3、Right join
select * from Table A right join Table B on Table A.id=Table B.id
RIGHT JOIN返回右表的全部行和左表满足ON条件的行,如果右表的行在左表中没有匹配,那么这一行左表中对应数据用NULL代替。
4、Full join
select * from Table A full outer join Table B on Table A.id=Table B.id
full join on = full outer join on,且兑换两个表的sql位置结果一样