locked
problem with oracle query for version8.1.7 RRS feed

  • Question

  • User-1556678718 posted

     Hello

    I am using most of the time SQL Server, however  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

    Wednesday, July 17, 2013 4:40 AM

Answers

  • User-18289217 posted
    Select * from table2 t2, table1 t1 Where t1.b1 = t2.a1(+) AND (t2.a2=t1.b2 or t2.a3=t1.b3)


    Basically when you do left outer join the (+) comes at the end of the statement. If you do right outer join it comes to the LEFT of equality operator e.g. Where t1.b1(+) = t2.a1

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, July 17, 2013 5:07 AM