05ddg17

mu

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

File Jel LJtilily Preferences Window Help

Recordsel (* Dynasel Type:    C Snapshol

r Table

Form

Type:

Dala Conlrol No Dala Conlrol DBGrid Conlrol

BeginTrans

| User: admin

H SQL Slalemenl

[S0C|WSQL Slalemenl

Refresh

Sorl

Filier

	CompanyName | Cily		ID
	Gourmel	Campinas	GOURL
	Wellinglon	Resende	WE LU
	Hanari Carnes	Rio de Janeiro	HANAR
	Que Delfcia	Rio de Janeiro	QUEDE
	Ricardo Adocicados	Rio de Janeiro	RICAR
	Comercio Mineiro	Sao Paulo	COMMI
	Familia Arquibaldo	Sao Paulo	FAMIA
	Queen Cozinha	Sao Paulo	QUEEN
±_	Refrescos Americana:! Sao Paulo		10
	1T radięao 1S ao Paulo 1T RAD H 1
d_

[7 AllowAddNew [7 AllowDelele |7 Allowl

| MI 4 I Righl Click for Dala Conlrol Properlies

Execule		Clear

J

FROM Suppliers WHERE C&nlry = "Braził"

UNION SELECT CompanyName, Cily, CuslomerlD FROM Cuslomers WHERE Counlry = "Braził"

ORDER BY City;

|Ready