Problem with query - 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

Other Forums

MS Access

Problem with query

Author

Topic

jte71
Starting Member

2 Posts

Posted - 2011-06-01 : 11:49:17

Hi guys,

I have a table (not made by myself) with 3 columns
- Employeenumber (number)
- EmployeeName (text)
- EmployeeManager (number) "is a record in Employeename"

On base of an Employeenumber I want the (Employee)Name of the EmployeeManager. My thoughts where to use the output from the first select, and use it as input for the second select. But I can't figure out how to do it.

Please help.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-06-01 : 11:54:12

SELECT A.EmployeeName Employee, B.EmployeeName Manager
FROM myTable A
INNER JOIN myTable B ON A.EmployeeManager=B.EmployeeNumber

jte71
Starting Member

2 Posts

Posted - 2011-06-02 : 11:33:23

Many thanks RobVol.

Kind regards

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources