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