Bhulu
I made lil changes in the exists subqueries.
(Query u sent selected the T1 row present in either
t2 or t3 which was correct , but what it also did :
t1 row got selected if t1.c2 = t2.c2 even if t2.c3
did not exist in t3.c3 (really complicated to explain
in brief) )
foll. query now works:
Sam,
I think this will work. Can you please try it out and
let me know if I understood your problem correctly.
select t1.c2,t1.c4,t23.c2,t23.c3,t4.c4
from t1,t4,( select t2.c2 c2 ,t2.c3 c3 from t2,t3
where t2.c3=t3.c3) t23
where t1.c4=t4.c4(+)
andt1.c2=t23.c2(+)
and exists
(
select 1
