6 Replies Latest reply on Jun 17, 2008 8:52 PM by 559287

    LEFT JOIN with OR

      How can I change "LEFT JOIN [table] ON[condition1] OR [condition2]" to an Oracle 8.1.6 compatible form? I shouldn't use PL/SQL because the solution has work on other server types as well. If there is no way to do this in standard SQL (without using temporary tables) a PL/SQL solution has to do.
      Has anyone had similar problems?

      Any help will be greatly appreciated.

      t. Timo