[Edit]
+
0
-
0
MySQL Full Outer Join
1 2 3 4 5SELECT * FROM `table1` LEFT JOIN `table2` ON `table2`.`column_name` = `table1`.`column_name` UNION SELECT * FROM `table2` RIGHT JOIN `table2` ON `table2`.`column_name` = `table1`.`column_name`;
1 2 3 4 5SELECT * FROM `table1` LEFT JOIN `table2` ON `table2`.`column_name` = `table1`.`column_name` UNION SELECT * FROM `table2` RIGHT JOIN `table2` ON `table2`.`column_name` = `table1`.`column_name`;