05ddg13

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