Cartesian outer join with plus-sign syntax

Hi

I want to perform a cartesian outer join with the old plus-sign syntax. So far I've come up with (and it works)

SELECT ...
FROM A,B
WHERE
case when A.X = A.X then 0 else 0 end =
case when B.X (+) = B.X (+) then 0 else 0 end

Both tables are referred to, table B with the plus-sign, so the outer join requirement is satisfied. The condition is always true, so the join is in effect cartesian.

Is there another (simpler) way to do this?

Regards,

Jaap. Received on Mon Dec 17 2007 - 02:10:45 CST