retrieving manager name from table containing eid, ename and mgrid

Question

Hi ,

I have a table like emp(empid,managerid,empname).i want to retrieve the employee details with their manager name.please help me writing the query .

thanks jaggs

Answer 1

0

I assume you also have a managers table that would contain something like (managerid, mangername) If so you can join your emp table to the manager table on managerid. Your query would resemble something like

 SELECT E.empid, E.empname, M.managername  
 FROM emp E  
      JOIN manager M on E.managerid = M.managerid

answered Sep 01 '11 at 09:15 PM

Tim
31.5k ● 20 ● 30 ● 116

there is no manager table ,managerid is the column which is nothing but the empid of the respective manager.so here I think I need to do self join but how i dont know.please help me

Sep 01 '11 at 09:49 PM happy

This should do it.

 SELECT A.EMPID, A.EMPNAME, B.EMPNAME AS MANAGER  
 FROM EMP A  
 JOIN EMP B ON A.MANGERID = B.EMPID

Sep 01 '11 at 09:58 PM Tim

(comments are locked)

retrieving manager name from table containing eid, ename and mgrid

Follow this question

Related Questions