05ddg11

^ VisData:E:\MSOffice\Access\Samples\Northwind.mdb

HH3

File Jet LJtilily Preferences Window Help

Recordset (* Dynaset Type:    C Snapshot

r Table

Form

Type:

Dala Conlrol No Dala Conlrol DBGrid Conlrol

BeginTrans

| User: admin

H SQL Statement

H0I3|HSQL Statement

Refresh

Sort

Filier

	CompanyName	Address	ShipAddress
	Around the Horn	120 Hanover Sq.	Brook Farm
	Around the Horn	120 Hanover Sq.	Brook Farm
	Around the Horn	120 Hanover Sq.	Brook Farm
	Around the Horn	120 Hanover Sq.	Brook Farm
	Around the Horn	120 Hanover Sq.	Brook Farm
	Chop-suey	Hauptstr. 29	Hauptstr. 31
	Chop-suey	Hauptstr. 29	Hauptstr. 31
	Chop-suey	Hauptstr. 29	Hauptstr. 31
	Chop-suey	Hauptstr. 29	Hauptstr. 31
	Chop-suey	Hauptstr. 29	Hauptstr. 31
	Chop-suey	Hauptstr. 29	Hauptstr. 31
	Chop-suey	Hauptstr. 29	Hauptstr. 31

w AllowAddNew W AllowDelele W AllowUpdć | N | Right Click for Data Conlrol Properlies

Execute	Clear | Sa

Customers.Address,

Orders.ShipAddress FROM Customers, Orders,

Cuslomers INNER JOIN Orders ON Customers.CustomerlD = Orders.CustomerlD WH E R E 0 rders. S hipAddress< > Customers.Address

J

|Ready