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

Article View: borland.public.interbase.sql

Article #106

Back to borland.public.interbase.sql Previous Next

#106

From: Frederic Gelinas
Date: Wed, 04 Jun 2008 01:21

11 lines
1267 bytes

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.

--

Technical Details

Message-ID: <4845ee2a$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!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>

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: "Frederic Gelinas" <frederic_gelinas@hotmail.com>
Subject: Re: Too slow... can't think of a faster way.
Newsgroups: borland.public.interbase.sql
References: <48455030@newsgroups.borland.com> <4845581a$1@newsgroups.borland.com> <48457e65$1@newsgroups.borland.com>
User-Agent: XanaNews/1.18.1.6
NNTP-Posting-Host: 74.12.225.203
Message-ID: <4845ee2a$1@newsgroups.borland.com>
Date: 3 Jun 2008 18:21:46 -0700
X-Trace: newsgroups.borland.com 1212542506 74.12.225.203 (3 Jun 2008 18:21:46 -0700)
Lines: 12
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!feeder.erje.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message