Hello,
I'm executing the following query in Oracle 9:
select t1.f1, t2.f2, t3.f3
from t1, t2, t3
where t1.f3=t2.f3(+) and t2.f4=t3.f4
and t1.f1 in (date1, date2, date3)
I expect to get all the dates in the result, but I get only those dates that are not null in table t2.(outer joint is ignored) It happens because of the joint t2.f4=t3.f4
I added the following condition:
and (t2.f4=t3.f4 or t2.f4 is null)
In that case I get all the dates, but
those who have values appear twice -
with the values and empty row
How can I get the correct results with all the dates?
Thank you in advance.
Alexandra