Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Cartesian outer join with plus-sign syntax

Cartesian outer join with plus-sign syntax

From: Jaap W. van Dijk <j.w.vandijk_at_hetnet.nl>
Date: Mon, 17 Dec 2007 00:10:45 -0800 (PST)
Message-ID: <29488316-4b03-4a78-87e5-9ba47c0074b6@x69g2000hsx.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US