The Tech Pursuit
The Dev Shelf
Pages
Home
Interview Questions
About Me
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.
January 21, 2011 at 12:21 PM
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
1 comment:
you make this work very easy for some of us.
Post a Comment