MySQL Full Outer Join

1
2
3
4
5
6
7
SELECT * 
FROM `users` 
LEFT JOIN `departments` ON `departments`.`id` = `users`.`department_id`
UNION
SELECT * 
FROM `users` 
RIGHT JOIN `departments` ON `departments`.`id` = `users`.`department_id`