[LeetCode] 1965. Employees With Missing Information

SELECT employee_id FROM (SELECT e.employee_id FROM employees AS e LEFT JOIN salaries AS s ON e.employee_id = s.employee_id WHERE s.salary IS NULL UNION SELECT s.employee_id FROM employees AS e RIGHT JOIN salaries AS s ON e.employee_id = s.employee_id WHERE e.name IS NULL)sub ORDER BY 1 OUTER JOIN : FULL OUTER JOIN , LEFT OUTER JOIN, RIGHT OUTER JOIN FULL OUTER JOIN = LEFT JOIN UNION RIGHT JOIN U..

2022.06.16