05vcg04

■

Microsoft Query

OB

File Edit View Format Table Criteria Becords Window Help

$QL

«#<#•

^1 Mzi\ rei (*?

Query1

ZET

publishers
*	♦
Address
City
Company Name
Fax
Name	♦

	PubID	Name	Company Name	Address	City	State	Zip	Telephone	Fax
►	12	Macmillan Education	Macmillan Education Lti	175 Fifth Ave	New York	NY	10010
	6	Computer Science Press	Computer Science Press	41 Madison Ave	New York	NY	10010	212-576-9400	212-689-2383
	13	McGraw-Hill	McGraw-Hill Inc	1221 Ave of the Americć	New York	NY	10020	212-512-2000
	17	Prentice Hall	Prentice Hall Div. of Sim	15 Columbus Cir.	New York	NY	10023	800-922-0579
	5	Brady Pub.	Brady Books Div. of Prei	15 Columbus Cir.	New York	NY	10023	212-373-8093	212-373-8292
	3	Bantam Books	Bantam Books Div of: B.	666 Fifth Ave	New York	NY	10103	800-223-6834	212-765-3869
	26	Wiley	John Wiley 8t Sons Inc.	605 Third Ave	New York	NY	10158	212-850-6000	212-850-6088

SQL

OK

Cancel

S.QL Statement:

SELECT publishers.PubID. publishers.Name.

publishers.'Company Name'. publishers.Address. publishers.City.

publishers.State, publishers.Zip. publishers.Telephone.

publishers. Fax

FROM publishers publishers

WHERE (publishers. State=’NY‘)

ORDER BY Zip

M14 jRecord: 1			I*

View/edit the SQL statement directly

NUM