problem with a query in orac le 8.1.7
I have to write a query in oracle 8.1.7
Normally in SQL it should look like this:
Select * from table1 t1
Left outer join table2 t2 on t2.a1=t1.b1 and (t2.a2=t1.b2 or t2.a3=t1.b3)
How would this look like in Oracle 8.1.7 because there is no left outer join there , mostly I am confused with the multiple conditions on the left outer join.