http://reddymsbitools.blogspot.com

Monday, 18 October 2010

SQL Server Self Join

Select e1.empno,e.mgrno,e2.empno,e2.mgrno from emp e1,emp e2 where e1.empno=e2.mgrno

No comments:

Post a Comment