Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT employee.EmployeeID, employee.FirstName, employee.ManagerID, manager.FirstName AS ManagerName
- FROM Employees AS employee
- JOIN Employees AS manager
- ON employee.ManagerID = manager.EmployeeID
- WHERE employee.ManagerID IN(3,7)
- ORDER BY employee.EmployeeID;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement