Re: Multiple Conditions for an Outer Join?

From: Richard Kuhler <noone_at_nowhere.com>
Date: Thu, 02 May 2002 21:20:27 GMT
Message-ID: <v4iA8.3849$M7.1387480@twister.socal.rr.com>

I don't follow. Can you explain to me where the duplicates come from?

Thanks,
Richard

Pablo Sanchez wrote:
>
> "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:20:27 CDT