samedi 3 octobre 2015

SQlite how to display employee and manger names in this table?

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