Guest User

Untitled

a guest
Jan 21st, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. 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