April 21, 2010

Self Join in SQL Server

SELECT EMP1.EMPID,EMP1.EMPName AS 'Employee Name',EMP2.EMPName AS 'Manager Name' FROM dbo.Employee EMP1,dbo.Employee EMP2
WHERE
EMP1.ManagerID = EMP2.EMPID

1 comment:

Unknown said...

you make this work very easy for some of us.

Post a Comment