1965.sql (240B)
1 SELECT employee_id 2 FROM ( 3 SELECT * FROM Employees LEFT JOIN Salaries USING(employee_id) 4 UNION 5 SELECT * FROM Employees RIGHT JOIN Salaries USING(employee_id) 6 ) AS T 7 WHERE salary IS NULL OR 8 name IS NULL 9 ORDER BY employee_id