Showing posts with label Manager Emp Query. Show all posts
Showing posts with label Manager Emp Query. Show all posts

Thursday, June 19, 2014

Manager Emp Query

select e.eid,e.ename,m.ename as manager from xxx as e left after xxx as m on e.mid=m.eid

WHERE XXX table name same Table