Re: Too slow... can't think of a faster way.

Article View: borland.public.interbase.sql

Article #108

Back to borland.public.interbase.sql Previous Next

#108

From: dan palley
Date: Wed, 04 Jun 2008 17:41

17 lines
1792 bytes

"Frederic Gelinas" <frederic_gelinas@hotmail.com> wrote in message 
news:4845ee2a$1@newsgroups.borland.com...
> dan palley wrote:
>
>> The left outer join will not exclude records where a.ARTRANSACTIONID
>> is null -- that's the whole point of using a left outer join.
>
> Yes, it does exclude record with null in a.ARTransactionID.  The left
> join would return all the record of ARITEM, even if there is no
> matching ARTRANSACTIONID, but it would not consider the records with a
> null value in the joined field.  Tested against an IB 7.5 database.

If there are records being excluded, it's probably some condition in the 
where clause and not the LEFT JOIN.  Feel free to upload a small sample 
database that demonstrates the problem if you don't agree.

Dan

Technical Details

Message-ID: <4846d372$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!feeder.erje.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<48455030@newsgroups.borland.com> <4845581a$1@newsgroups.borland.com> <48457e65$1@newsgroups.borland.com> <4845ee2a$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,a4b1f4361f20c519
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "dan palley" <dan@trams.com>
Newsgroups: borland.public.interbase.sql
References: <48455030@newsgroups.borland.com> <4845581a$1@newsgroups.borland.com> <48457e65$1@newsgroups.borland.com> <4845ee2a$1@newsgroups.borland.com>
Subject: Re: Too slow... can't think of a faster way.
Date: Wed, 4 Jun 2008 10:41:46 -0700
Lines: 19
Organization: TRAMS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.3959
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.4133
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 66.102.131.254
Message-ID: <4846d372$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1212601202 66.102.131.254 (4 Jun 2008 10:40:02 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!feeder.erje.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message