SELECT * FROM t1 LEFT JOIN t2 ON t1.id = t2.id UNION SELECT * FROM t1 RIGHT JOIN t2 ON t1.id = t2.id
mysql 实现全连接
原文：https://www.cnblogs.com/dongshenjun/p/14118484.html
