help with query

HI I have a table that someone else designed like
*********************************************
* employeeid * firstname * last name * supervisor_id *
*********************************************
* 1 * Paul * Sed * 2
*
*********************************************
* 2 * John * Edward * 1 *
*********************************************
I need a query that will return Johns name for Pauls supervisor
(supervisorid=2)
and Pauls name for Johns supervisor, supervisor id for Johns supervisor is 1
which is the employeeid for Paul. Thanks.
Paul G
Software engineer.
Why is it that these two people are each other's supervisor?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:924257B5-2D18-4C2F-84F5-8C9C7BAA2AEC@.microsoft.com...
HI I have a table that someone else designed like
*********************************************
* employeeid * firstname * last name * supervisor_id *
*********************************************
* 1 * Paul * Sed * 2
*
*********************************************
* 2 * John * Edward * 1 *
*********************************************
I need a query that will return Johns name for Pauls supervisor
(supervisorid=2)
and Pauls name for Johns supervisor, supervisor id for Johns supervisor is 1
which is the employeeid for Paul. Thanks.
Paul G
Software engineer.
|||select t.FirstName,t.LastName,b.FirstName as 'Supervisor FirstName',
b.LastName as 'Supervisor FirstName' from
#temp t join #temp b
on b.employeeid=t.supervisor_id
#temp =Table Name
Sam
"Tom Moreau" wrote:

> Why is it that these two people are each other's supervisor?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:924257B5-2D18-4C2F-84F5-8C9C7BAA2AEC@.microsoft.com...
> HI I have a table that someone else designed like
> *********************************************
> * employeeid * firstname * last name * supervisor_id *
> *********************************************
> * 1 * Paul * Sed * 2
> *
> *********************************************
> * 2 * John * Edward * 1 *
> *********************************************
> I need a query that will return Johns name for Pauls supervisor
> (supervisorid=2)
> and Pauls name for Johns supervisor, supervisor id for Johns supervisor is 1
> which is the employeeid for Paul. Thanks.
> --
> Paul G
> Software engineer.
>
|||this is actually not the case, just a simplified example.
Paul G
Software engineer.
"Tom Moreau" wrote:

> Why is it that these two people are each other's supervisor?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:924257B5-2D18-4C2F-84F5-8C9C7BAA2AEC@.microsoft.com...
> HI I have a table that someone else designed like
> *********************************************
> * employeeid * firstname * last name * supervisor_id *
> *********************************************
> * 1 * Paul * Sed * 2
> *
> *********************************************
> * 2 * John * Edward * 1 *
> *********************************************
> I need a query that will return Johns name for Pauls supervisor
> (supervisorid=2)
> and Pauls name for Johns supervisor, supervisor id for Johns supervisor is 1
> which is the employeeid for Paul. Thanks.
> --
> Paul G
> Software engineer.
>
|||ok thanks I think that is what I was looking for.
Paul G
Software engineer.
"bluefish" wrote:
[vbcol=seagreen]
> select t.FirstName,t.LastName,b.FirstName as 'Supervisor FirstName',
> b.LastName as 'Supervisor FirstName' from
> #temp t join #temp b
> on b.employeeid=t.supervisor_id
> #temp =Table Name
> Sam
>
> "Tom Moreau" wrote: