How to find Manager name of Employee

Question

Suppose there is one table which contains Column as EidEnameMgrId from this we have to find the Manager name of Employee

Praveen Dhatrika · Answer

you should make sure you join the tble with another table that has MgrId MgrName as columns Let's take example as Emptable Mgrtable --------------------------- ---------------------------------- EIDENameMgrID MrgID MgrName Select E.ENameM.MgrName from EmpTable E join MgrTable M on E.MgrID==M.MgrID learn more about joins from here http://www.w3schools.com/sql/sql_join.asp If you find my post as useful then accept my reply as answer. :)