MySQL Full Join using UNION
The simple solution here would be to do full outer join and find the id\'s without salary or name\nUnfortunately, We don\'t have FULL OUTER JOIN in MySQL, to ac
The simple solution here would be to do full outer join and find the id\'s without salary or name\nUnfortunately, We don\'t have FULL OUTER JOIN in MySQL, to achieve that we can create it using UNION of left outer and right outer\n\n```\n# Write your MySQL query statement below\n\nSELECT res.employee_id FROM\n(\n    SELECT *\n    FROM employees\n    LEFT OUTER JOIN salaries\n    USING (employee_id)\n    \n    UNION\n    \n    SELECT *\n    FROM employees\n    RIGHT OUTER JOIN salaries\n    USING (employee_id)\n) res\nWHERE name IS NULL \nOR salary IS NULL\nORDER BY employee_id;\n```
['Union Find', 'MySQL']