View Single Post
  #1 (permalink)  
Old July 17th, 2013, 01:12 AM
Barbi Barbi is offline
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default problem with a query in orac le 8.1.7

Hello,
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.

Thanks