Xfigs11

Publishing - Microsoft Developer Studio - [authors : Query (pubs) “]

File Edit View insert Project Build £uery Jools Window Help

!

•i &

fl    te,§* % p^hone

_l2£i

B -0 pubs (PENTIUM)

S 1_] Database Diagrams $■•0 Tables Ś-i authors ^ aujd ^ au Iname

au_ phone address ^ city State

CU zip

m contract U discounts ŚHID employee i -i jobs ŚHID pubjnfo ŚHID publishers ŚHID roysched [+] HU] sales ŚHm Stores ś-U sysproperties Ś 001 titleauthor Śdlii titles P~1 Views

n Stored Procedures

Ś

5 Cl... gR... i) Fil... ij D... ^ In...

Ready

H authors

□

~3\<p -►©

* (Ali Columns)

□	aujd
✓	au Iname
✓	au_fname
✓	phone

Oa □ SOI I oP W! ::*■ *!    | ^ a! I Ef

Column

Alias

Table

Output

Sort Type

Sort Order

Criteria

-

au Iname

authors

✓ V/

au fname

authors

phone

authors

V/

dJ iT

SELECT aujname, au fname, phone FROM authors

d ▼

au Iname

au fname

phone

address

City

▲

►

172-32-1176

White

Johnson

408 496-7223

10932 Bigge Rd.

Menlo

213-46-8915

Green

Marjorie

415 986-7020

309 63rdSt. 8411

Oaklar

238-95-7766

Carson

Cheryl

415 548-7723

589 Darwin Ln.

Berkel

267-41-2394

0‘Leary

Michael

408 286-2428

22 Cleveland Av. 8

San Jc

274-80-9391

Straight

Dean

415 834-2919

5420 College Av.

Oaklar

341-22-1782

Smith

Meander

913 843-0462

10 Mississippi Dr.

Lawre

409-56-7008

Bennet

Abraham

415 658-9932

6223 Bateman St.

Berkel

427-17-2319

Duli

Ann

415 836-7128

3410 Blonde St.

Pało A

< |

Gfinolesbu

Burt

707 938-6445

PO Box 792

^C°_iJ

Start

r;. Mai...

t^PA...

eysQ-

gjj \\P...

UJFMic...

t^PA...

0 Aut...

E"-l Kate

*> m c

IFre...

1:30 PM