06fig05a

Visual Data

File labie Query! Utility Preferences Window

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

E:\VB4B00K\SAMPLESVT -

SQL Statement

BeginTransaction

SnapShot: INNERJ0IN2 [8 rows]

Create HueryDef

Next

First Morę

Find

Redo Filier Sort Close

	LASTNAME |FIRSTNAME SALESLAST SALESFIRST
1	Smith	Maureen Green Elizabeth
2	Smith Adam		Walsh	Bill
3	Smith Zachary		Green	Elizabeth
4	Johnson Williams	Warren	Burns	John
5		Stephanie	Green	Elizabeth
6	T aylor	Lisa	Walsh	Bill
7	Davis	David	Burns	John
8	Roberts Judy Walsh Bill

wherejoin

Ready