Xfigs10

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

IIP File Edit View insert Project Build £uery Jools Window Help

!

•i &

O -r CS

?? % P^hone

_l*

□■■•■8 pubs (PENTIUM)

0 |_| Database Diagrams $■•0 Tables Ś-I authors d aujd d au Iname

au_

d phone d address d city d State

d zip

m contract m discounts d employee d jobs d pub_info d publishers d roysched d sales 0 d Stores ♦ □ sysproperties B d titleauthor B-d titles B O Views B O Stored Procedures

B

j Cl-1 fcjl R- -1 JQ Fil...| jij D...pg~in

Ready

11

author

u o-►©

»/ * (Ali Columns) aujd au_lname au_fname phone

_

d

on a w ra nil ^l»! -Pi X!

^ j IB m 1 ES

	Column	Alias	Table | Output				Sort Type	Sort Order	Criteria	▲
	^x		authors		✓
										i
										Zł

SELECT

FROM

authors*

authors

	au id	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. #411	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. # SanJc
	274-80-9391	Straight	Dean	415 834-2919	5420 College Av.	Oaklar
	341-22-1782	Smith	Meander	913 843-0462	10 Mississippi Dr.	Lawrei
	409-56-7008	Bennet	Abraham	415 658-9932	6223 Bateman St.	Berkel
	427-17-2319 A "7'1 'V? '^mt'1An	Duli r-.:.. .i. -l..	Ann n. ..i	415 836-7128 Tn-7 n^n rA au	3410 Blonde St. nn n ... “?nn	Pało A w

Ti, Mai...

t^PA...

eyso-

gjj \\P...

UJFMic...

t^PA...

§ Aut...

(^■-1 Kate

m c

tt©P...

i Fre.

1:23 PM