两张表都有的以及某一张表独有的数据,并剔除重复数据
摘要:left join union right join
SELECT a,id a.name b.age from tablea as a LEFT JOIN tableb as b on a.id=b.id
UNION
SELECT a,id a.name b.age from tablea as a RIGHT JOIN tableb as b on a.id=b.id;
两张表都有的以及某一张表独有的数据,并剔除重复数据
摘要:left join union right join
SELECT a,id a.name b.age from tablea as a LEFT JOIN tableb as b on a.id=b.id
UNION
SELECT a,id a.name b.age from tablea as a RIGHT JOIN tableb as b on a.id=b.id;