how to using as (alias) - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

how to using as (alias)

Author

Topic

demonicius
Starting Member

10 Posts

Posted - 2009-10-13 : 11:26:59

hi guys i am newbie, pliss help me, i have some question,

1.show employee names and department names of his first name beginning with the letter a (empolyees name and departement)

2.show name employee, department number and the manager of employee id which is located in the city of seattle

table
from employees

employee_id first_name departemen_id
200 jennifer 10

from department

department_id department_name manager id location
10 Administration 200 1700

from location

locatin_id city
1700 seattle

hi pliss teach me sql

X002548
Not Just a Number

15586 Posts

Posted - 2009-10-13 : 11:57:18

when is the assignment due?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam