I have two table employee table and employee dependency table. Employee tooks like below.

insert into E values(1,'Adam') insert into E values(2,'Bob') insert into E values(3,'Candy') insert into E values(4,'Doug') insert into E values(5,'Earl') insert into E values(6,'Fran')

Employee dependency table looks like below

insert into Ed values(3,'2') insert into Ed values(3,'5') insert into Ed values(2,'1') insert into Ed values(2,'4') insert into Ed values(5,'6')

I need to find the dependency list like below

Eid Ename Dname 3 Candy Bob,Fran

Please help me finding the above.