sql query

i have an sql table with table strucutre

id  autonumber
supervisorid number
firstname text
lastname text

how can i write a query to get a report to who is the supervisor for an employee

like
employeefirst and lastname and supervisor for that employee.

romeiovasuAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
David ToddConnect With a Mentor Senior DBACommented:
Hi,

The answer is to do a self-join

HTH
  David
select
	e.firstName as EmFirst
	, e.lastName as EmLast
	, isnull( s.firstName, '' ) as SupFirst
	, isnull( s.lastName, '' ) as SupLast
from dbo.Employees e
left outer join dbo.Employees s
	on e.SuperviserID = s.ID

Open in new window

0
All Courses

From novice to tech pro — start learning today.