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 -> Re: Multiple Conditions for an Outer Join?

Re: Multiple Conditions for an Outer Join?

From: Pablo Sanchez <pablo_at_dev.null>
Date: Thu, 2 May 2002 15:01:21 -0600
Message-ID: <DOhA8.2210$VQ6.548039@news.uswest.net> 






"Richard Kuhler" <noone_at_nowhere.com> wrote in message
news:hggA8.75781$zN.41161099_at_twister.socal.rr.com...


> and (table2.t1_id is null or table2.x = 12345 or table2.x = 12346)




I believe an issue with the above is that you end up with duplicates.
Of course a DISTINCT will solve that but was looking at the request's
prereq of 'efficient.'

--
Pablo Sanchez, High-Performance Database Engineering
mailto:pablo_at_hpdbe.com
http://www.hpdbe.com
Available for short-term and long-term contracts


Received on Thu May 02 2002 - 16:01:21 CDT












Original text of this message













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