关于join
2023-04-20 本文已影响0人
Yluozi
有表tabe1
image.png
有表tabe0
image.png
‘,’全查、并集
select * from table0,table1
image.png
select * from table0 left join table1 on table0.id = table1.sid
image.png
select * from table0 right join table1 on table0.id = table1.sid
image.png
select * from table0 INNER JOIN table1 on table0.id = table1.sid
image.png
select * from table0 JOIN table1 on table0.id = table1.sid
image.png
select * from table0 STRAIGHT_JOIN table1 on table0.id = table1.sid
image.png
‘FULL JOIN/OUTER JOIN’全查、并集（oracle） mysql报错
select * from table0 FULL JOIN table1 on table0.id = table1.sid
image.png
