i am new to SQLite. I want to display the name of each employee and his/her manager's name. But i am a little confused about how to link the managerID with EmployeeID? Do i need to use subquery?
table: Employee
Columns: EmployeeID [pk], EmployeeName, ManagerID
Like:
EmployeeID EmployeeName ManagerID
1 Alice 2
2 Peter null
3 John 2
4 Mary 1
means Peter is Alice and John's manager and Alice is Mary's manager.
SELECT EmployeeName AS Employee, EmployeeName AS Manager
FROM Employee
WHERE
Aucun commentaire:
Enregistrer un commentaire