ANSI Outer Joins

We have an application which runs on a number of other databases, and we now need to port to Oracle.

The main problem we have, is that our SQL uses the ANSI standard SQL-92 outer join syntax, which allows multi-table outer joins. I have looked on dejanews.com and can't find an answer to the problem, just discussion about levels of compliance with SQL-92. We need to be able to achieve the same affect as

select a.col1, b.col2, c.col3
from a, b, c

where a.col1(+) = b.col1
  and a.col2(+) = c.col1
  and b.col4=c.col4

which would be possible using SQL-92 syntax, which is supported by the other databases, but appears not to be using Oracle.

TIA Simon Received on Thu Nov 12 1998 - 04:31:41 CST