Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Multiple Conditions for an Outer Join?
"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 contractsReceived on Thu May 02 2002 - 16:01:21 CDT