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