Help me finding dependency list.
- by Pearl
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.