06fig05c

06fig05c



Visual Data

File labie Query! Utility Preferences Window

RecordSet Form Type:    Q Dat a Control O No Data Control <§> Grid

SQL Statement


BeginTransaction


E:\VB4B00K\SAMPLESVT -

New


Open


Design


EsreeuU* SiSII. |

Clear SQL

Create QueryDef |

EU S.QL PassThrough


Tables/Queries:


Customers

innerjoin

INNERJ0IN2

leftjoin

Name

nameid

Query1

Query2

Retail Items


Sales

Salesmen

testl

wherejoin


SnapShot: RIGHTJOIN [9 rows]


Next

First

Morę

Find

Redo

Filier

Sort

Close

LASTNAME FIRSTNAME SALESLAST SALESFIRST

1

Davis

David Burns John

2

Johnson

Williams

Warren

Burns

John

3

Stephanie

Green

Elizabeth

4

Smith

Zachary

Green

Elizabeth

5

Smith

Maureen

Green

Elizabeth

6

Roberts

Judy

Walsh

Bill

7

T aylor

Lisa

Walsh

Bill

8

Smith

Adam

Walsh

Bill

9

Johnson Mary


Ready


Wyszukiwarka

Podobne podstrony:
06fig05a Visual DataFile labie Query! Utility Preferences Window RecordSet Form Type: Q Dat a Contro
06fig05b Visual DataFile labie Query! Utility Preferences Window RecordSet Form Type: Q Dat a Contro
06fig05c Visual DataFile labie Query! Utility Preferences Window RecordSet Form Type: Q Dat a Contro
06fig07 Visual DataFile labie Query! Utility Preferences Window RecordSet Form Type: Q Dat a Control
06fig05a Visual DataFile labie Query! Utility Preferences Window RecordSet Form Type:   &n
06fig05b Visual DataFile labie Query! Utility Preferences Window RecordSet Form Type:   &n
06fig07 Visual DataFile labie Query! Utility Preferences Window RecordSet Form Type:   &nb
06fig02 Visual Data File labie Query! Utility Preferences Window RecordSet Form Type: Q Dat a Contro
06fig03 Visual Data File labie Query! Utility Preferences Window RecordSet Form Type: Q Dat a Contro
06fig03 Visual Data File labie Query! Utility Preferences Window RecordSet Form Type:   &n
06fig03 Visual Data File labie Query! Utility Preferences Window RecordSet Form Type:   &n
06fig02 Visual Data File labie Query! Utility Preferences Window RecordSet Form Type:   &n
06fig08 Visual DataFile labie Query! Utility Preferences Window BeginTransaction RecordSet Form Type
06fig08 Visual DataFile labie Query! Utility Preferences Window BeginTransaction RecordSet Form Type
06fig01 Visual Data File labie Query! Utility Preferences Window BeginTransaction RecordSet Form Typ
06fig04 Visual Data File labie Query! Utility Preferences Window BeginTransaction RecordSet Form Typ
06fig09 Visual Data File labie Query! Utility Preferences Window BeginTransaction RecordSet Form Typ
06fig01 Visual Data File labie Query! Utility Preferences Window BeginTransaction RecordSet Form Typ
06fig04 Visual Data File labie Query! Utility Preferences Window BeginTransaction RecordSet Form Typ

więcej podobnych podstron