Hi,
I have 5 tables A,B,C,D,E
A
Investment_detail_ID
B
Investment_detail_ID
Investment_id
c
Investment_id
Deal_id
D
Deal_id
E
Deal_ID
on Joining the A,B,C,D I get some deal_ids.Now if I have to find out which ids of these result set are not there in table of e, how can join tables??Currently I have A and B joined on Investment_detail_id, B and C joined on Investment_id , c and d joined on deal_id, and now how shall i join d and e.If i join them on deal_id, i miss those deal_id which i get from the combination of A,B,C,D.Can outer join be the solution.
If so,How??which tables shall i perform outer joins on.My report will require the data fromtable A and E.
Thanks
I have 5 tables A,B,C,D,E
A
Investment_detail_ID
B
Investment_detail_ID
Investment_id
c
Investment_id
Deal_id
D
Deal_id
E
Deal_ID
on Joining the A,B,C,D I get some deal_ids.Now if I have to find out which ids of these result set are not there in table of e, how can join tables??Currently I have A and B joined on Investment_detail_id, B and C joined on Investment_id , c and d joined on deal_id, and now how shall i join d and e.If i join them on deal_id, i miss those deal_id which i get from the combination of A,B,C,D.Can outer join be the solution.
If so,How??which tables shall i perform outer joins on.My report will require the data fromtable A and E.
Thanks