05ddg13

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


Wyszukiwarka

Podobne podstrony:
05ddg13 mu VisDala:E:MSOfficeAccessSamplesNorthwind.mdb File Jel LJtilily Preferences Window
05ddg17 mu VisDala:E:MSOfficeAccessSamplesNorthwind.mdb File Jel LJtilily Preferences Window
05ddg12 VisData:E:MSOfficeAccessSamplesNorthwind.mdb File Jel LJtilily Preferences Window
05ddg11 ^ VisData:E:MSOfficeAccessSamplesNorthwind.mdbHH3 File Jet LJtilily Preferences Window
05ddg06 M VisData:E: WB4Biblio.mdb File Jet LJtilily Preferences Window Help unin Recordset (* Dynas
05ddg03 M VisDala:E: WB4Biblio.mdbHHa File Jet LJtilily Preferences Window Help Recordsel (• pynasel
05ddg18 M VisData:E: WB4Biblio.mdbmu File Jet LJtilily Preferences Window Help Recordsel (* Dynasel
06fig12 VisData:E:VB4B00KSAMPLE STRITON.MDB zh.File Jet Utility Preferences Window Help Form Type:
Etap 1 8 Microsoft Access - [Samochody : Table]i0G File Edit View Insert Jools Window Help Type a
Etap 3 1 Microsoft Access - [Typ_aut: Tabie] File Edit View insert Format Records Jools Window
Etap 6 1 Microsoft Access - [Raportl ] ^ File Edit View Tools Window Help ^ Close Setup ^ J _3 »■

więcej podobnych podstron