left join(左联接) 返回包括左表中的所有记录和右表中联结字段相等的记录
right join(右联接) 返回包括右表中的所有记录和左表中联结字段相等的记录
inner join(等值连接) 只返回两个表中联结字段相等的行
Example:
--------------------------------------------
a表:
id name
1 a
2 b
3 c
b表:
id score
1 99
2 95
5 98
--------------------------------------------
1.left join
select * from a left join b on a.id = b.id
Results:
a.id name b.id score
1 a 1 99
2 b 2 95
3 c null null
2.right join
select * from a right join b on a.id = b.id
Results:
a.id name b.id score
1 a 1 99
2 b 2 95
null null 5 98
3.inner join
select * from a inner join b on a.id = b.id
Results:
a.id name b.id score
1 a 1 99
2 b 2 95
【SQL】 left join、right join and inner join的区别
最新推荐文章于 2024-07-13 14:12:16 发布