MySQL ||  UNION || Easy to understand
\n# Code\n\n# Write your MySQL query statement below\nselect e.employee_id from employees e  left join salaries s on e.employee_id=s.employee_id where s.salary 
\n# Code\n```\n# Write your MySQL query statement below\nselect e.employee_id from employees e  left join salaries s on e.employee_id=s.employee_id where s.salary is null\nunion \nselect s.employee_id from salaries s  left join employees e on e.employee_id=s.employee_id where e.name is null\norder by employee_id;\n\n```\n\n```please upvote, if you find it useful```
['MySQL']