思路1
SELECT s.id, s.name
FROM Students s LEFT JOIN Departments d
ON s.department_id=d.id
WHERE d.id IS NULL;
Last updated
Was this helpful?
SELECT s.id, s.name
FROM Students s LEFT JOIN Departments d
ON s.department_id=d.id
WHERE d.id IS NULL;
Last updated
Was this helpful?