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

Home -> Community -> Usenet -> comp.databases.theory -> Re: difference between UNION operator and OR in where clause

Re: difference between UNION operator and OR in where clause

From: Lennart <erik.lennart.jonsson_at_gmail.com>
Date: Tue, 10 Jul 2007 20:06:18 +0200
Message-ID: <f70hqq$miq$2@registered.motzarella.org> 





Mike wrote:


> 

> However, if using solution 2 with "select DISTINCT", it will output 3

> titles instead.

> 




Yes, but I think you are missing the point. Focus on what Bob is trying 
to show you, and I think you will get the picture.



/Lennart
Received on Tue Jul 10 2007 - 13:06:18 CDT












Original text of this message













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