⭐TWO METHODS BY Using JOINS and UNION (Full outer join) || mySQL⭐
\uD83D\uDE0APLEASE UPVOTE IF YOU FIND USEFUL \uD83D\uDE0A\nFull outer join is not supported in mySQL , instead we use UNION\nMethod1\n\nSELECT employee_id from 
**\uD83D\uDE0APLEASE UPVOTE IF YOU FIND USEFUL \uD83D\uDE0A**\n*Full outer join is not supported in mySQL , instead we use UNION*\n**Method1**\n```\nSELECT employee_id from Employees e WHERE employee_id not in (Select employee_id from Salaries)\nUNION \nSELECT employee_id from Salaries s WHERE employee_id not in (Select employee_id from Employees)\nORDER BY employee_id;\n```\n**Method2**\n```\nSelect e.employee_id from Employees e \nLEFT JOIN Salaries s \nON e.employee_id = s.employee_id\nWHERE s.salary  is NULL\n\nUNION\n\nSelect s.employee_id from Salaries s\nLEFT JOIN Employees e \nON e.employee_id = s.employee_id\nWHERE e.name is NULL\n\nORDER BY employee_id;\n```
['Union Find', 'MySQL']