06fig05b

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

	SiSII. |	Clear SQL	Create Q.ueryDef |

SnapShot: LEFTJOIN [10 rows]

Next First Morę Find Redo Filier Sort Close

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

Tables/Q

Custome

innerjoin

INNERJt

Name nameid Query1 Query2 Retail Itr rightjoin Sales Salesmei testl wherejoii

Ready