数据库结构
表a
表b
LEFT JOIN
a left join b
b left join a
RIGHT JOIN
a right join b
b right join a
INNER JOIN
a inner join b
b inner join a
数据库结构
表a
表b
LEFT JOIN
a left join b
b left join a
RIGHT JOIN
a right join b
b right join a
INNER JOIN
a inner join b
b inner join a