题目描述
leetcode题目:1965. 丢失信息的雇员
Code
select A.employee_id
from (
select employee_id
from Employees
union
select employee_id
from Salaries
) A
left join Employees
on Employees.employee_id = A.employee_id
left join Salaries
on Salaries.employee_id = A.employee_id
where name is null or salary is null
order by A.employee_id