Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT employees.name FROM employees LEFT JOIN (SELECT tb1.id AS workers, tb1.name AS name, managers.id AS manager FROM employees AS tb1 LEFT JOIN employees AS managers ON tb1.managerId = managers.id WHERE tb1.managerId NOT NULL AND managers.id NOT NULL GROUP BY tb1.id) AS managers ON employees.id = managers.manager WHERE managers.workers IS NULL
Add Comment
Please, Sign In to add comment