mu
VisDala:E:\MSOffice\Access\Samples\Northwind.mdb
File Jel LJtilily Preferences Window Help
Recordsel (* Dynasel Type: C Snapshol
r Table
Form
Type:
Dala Conlrol No Dala Conlrol DBGrid Conlrol
BeginTrans
| User: admin
H SQL Slalemenl
[S0C|WSQL Slalemenl
Execule |
Clear | ||
Refresh
Sorl
Filier
EmpID |
Employee |
SupID |
Supervisor | |
► |
1 |
Davolio, Nancy |
2 |
Fuller, Andrew |
3 |
Leverling, Janel |
2 |
Fuller, Andrew | |
4 |
Peacock, Margarel |
2 |
Fuller, Andrew | |
5 |
Buchanan, Sleven |
2 |
Fuller, Andrew | |
6 |
Suyama, Michael |
5 |
Buchanan, Sleven | |
7 |
King, Roberl |
5 |
Buchanan, Sleven | |
8 |
Callahan, Laura |
2 |
Fuller, Andrew | |
9 |
Dodsworlh, Annę |
5 |
Buchanan, Sleven | |
* |
[7 AllowAddNew W AllowDelele W AllowUpdale
| N | 4 | Righl Click for Dala Conlrol Properlies
SELECT Employees.EmployeelD AS EmpID, - | Employees.LaslName St" 8c Employees.FirslName AS Employee, Employees.ReporlsTo AS SupID, EmpCopy.LaslName & "," St EmpCopy.FirslName AS Supervisor FROM Employees, Employees AS EmpCopy,
Employees INNER JOIN EmpCopy ON Employees.ReporlsTo =
E mpCopy. E mployeel D
J
|Ready