[Edit]
+
0
-
0
MySQL FULL OUTER JOIN
1 2 3 4 5SELECT * FROM table_a A LEFT JOIN table_b B ON A.key = B.key UNION SELECT * FROM table_a A RIGHT JOIN table_b B ON A.key = B.key
1 2 3 4 5SELECT * FROM table_a A LEFT JOIN table_b B ON A.key = B.key UNION SELECT * FROM table_a A RIGHT JOIN table_b B ON A.key = B.key