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 -> AND, OR can not be used in an outer join condition?

AND, OR can not be used in an outer join condition?

From: <gmei_at_my-deja.com>
Date: Tue, 28 Nov 2000 03:27:16 GMT
Message-ID: <8vv8me$sl9$1@nnrp1.deja.com> 






Hi:



I am trying to understand the following question:



Q: Which two operators can not be used in an outer join condition?



    
  
  1.   =
  
  2.   IN
  
  3.   AND

  
  4.   OR






Answer is c and d.



I understand "=" can be used in outer join condition. Could some one give
examples of how to use "IN" in an outer join and what kind of error "AND"
and "OR" would generate in an outer join condition?



Thanks.



Guang




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Mon Nov 27 2000 - 21:27:16 CST












Original text of this message













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