Xfigs12

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

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

!

•i &

& mm o.' Ol w

?? % p^hone

_l*

□■■•■8 pubs (PENTIUM)

S |_| 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 IŚ (0!1 pubjnfo IŚ (0!1 publishers IŚ (mi roysched m m sales Ś (0!1 Stores El d sysproperties I-i titleauthor ś mu tities Pi Views

n Stored Procedures

Ś

3 Cl...    R... \g\ Fil... |j D... $ In

Ready

author

* (Ali Columns) aujd

* aujname */ au fname

phone    z 1

_

z\

~B o -►©

	Column	Alias	Table	Output			Sort Type	Sort Order	Criteria
	au Iname		authors		✓ V/
	au fname		authors
	phone		authors		✓		Ascending	1

SELECT

FROM

aujname, aujname, phone authors

	au Iname	au fname	phone
►		Michel	219 547-9982
	Panteley	Sylvia	301 946-8853
	0‘Leary	Michael	408 286-2428
	White	Johnson	408 496-7223
	MacFeather	Stearns	415 354-7128
	Karsen	Livia	415 534-9219
	Carson	Cheryl	415 548-7723
	Locksley	Charlene	415 585-4620
	Bennet	Abraham	415 658-9932
	Straight	Dean	415 834-2919

d

r;. Mai...

t^PA...

eyso...

gjj \\P...

R^Mic...

t^PA...

0 Aut...

(^■-I Kate

*> m c

i Fre.

1:32 PM