Please help with the following simple query

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi I have the following table struture:
test[emp_name,emp_id,dept,mgr_id,sal].
Now I want to display all the employees emp name,dept along with their manager name.
I have written the following query:
select emp_name,emp_id,mgr_id from test t1,
emp_name as manager_name from test t2 where
t1.mgr_id=t2.emp_id
but it's giving the following error:
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'from'.

Posted 3-May-10 20:53pm

avishekrc

Updated 3-May-10 21:02pm

Abhinav S

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2010-05-03T21:01:00

Solution 1

Try

SQL

select t1.emp_name,t1.emp_id,t1,mgr_id,
t2.emp_name as manager_name from testt1, test t2 where
t1.mgr_id=t2.emp_id

Posted 3-May-10 21:01pm

Abhinav S

Please help with the following simple query

1 solution

Solution 1

Add your solution here

Preview 0

Please help with the following simple query

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us