Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Outer Join and IN Predicate...a Question
Hi,
Does any one know, how to use Outer Join with In clause. I have a 3
column join of two tables and an in clasue in the where as
WHERE Table1.A (+) = Table2.A AND
Table1.B (+) = Table2.B AND Table1.C (+) = Table2.C AND Table1.D (+) IN ('one','two','three'); // Outer is not allowed here. SoI replaced the above line with
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Mar 14 2000 - 00:00:00 CST