05ddg12

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

File Jel LJtilily Preferences Window Help

HE

Recordsel (* Dynasel Type:    C Snapshol

r Table

Form

Type:

Dala Conlrol No Dala Conlrol DBGrid Conlrol

BeginTrans

| User: admin

§=! SQL Statement

Refresh

Sorl

Filier

CompanyName | Add?

I ShipAddress

Around Ihe Horn

120 Hanover Sq.

Brook Farm

^ SQL Statement

Execule		Clear		Sa

SELECT DISTINCT Cuslomers.CompanyName, Cuslomers. Address, 0 rders. S hipAddress FROM Cuslomers, 0 rders

WHERE Cuslomers.CuslomerlD = 0rders.CuslomerlD AND 0rders.ShipAddress <> Cuslomers.Address

□

Chop-suey Chinese

Laughing Bacchus

Richler Supermarkl

While Clover

Hauplslr. 29

1900 Oak Sl.

Grenzacherweg

305 - 14lh Ave. S.

Hauplslr. 31

2319 Elm Sl.

Slarenweg 5

1029 -12lh

W AllowAddNew W AllowDelele W AllowUpdć | N | 4 | Righl Click for Dala Conlrol Properlies

|Ready

J