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
 SQL Server 2008 Forums
 Transact-SQL (2008)
 how to using as (alias)

Author  Topic 

demonicius
Starting Member

10 Posts

Posted - 2009-10-14 : 00:00:52
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

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-10-14 : 00:12:55
duplicate thread http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=134381


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -