05vcg04

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


Wyszukiwarka

Podobne podstrony:
05vcg03 File Edit View Format Table Criteria Becords Window Help ^ O SQl ^ % £i
01vcg01 Microsoft Query - [Query1] File Edit View Format Table Criteria Becords Windowmg fFEtil
07vcg15 @ Microsoft Query File Edit View Format Table Criteria Records Windo w Help6&W (f &
07vcg16 Microsoft QueiyFile Edit View Format Table Criteria Records Windo w Help ^ 13 SQl <§ a
07vcg17 Microsoft QueiyFile Edit View Format Table Criteria Records Windo w Help <#1#
07vcg18 Microsoft Query File Edit View Format Table Criteria Records Windo w Help ^□stdregl.ąiyCours
07vcg20 @ Microsoft Query File Edit View Format Table Criteria Records Windo w HelpMWJMM & g $QL
f10 1 <i> Netscape - [On-Line Catalotj] File Edit View Go Bookmarks Options Directory Window H

więcej podobnych podstron