MYSQL查询两张表并集

两张表都有的以及某一张表独有的数据，并剔除重复数据
摘要：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;