Article View: borland.public.interbase.sql
Article #11222Re: left join in TIBDataSet
From: Wayne Niddery [TeamB]
Date: Thu, 12 Dec 2002 05:00
Date: Thu, 12 Dec 2002 05:00
18 lines
1943 bytes
1943 bytes
"Brian Cook" <bcook@rowdydogsoftware[REMOVE].com> wrote in message news:3df7a06e$1@newsgroups.borland.com... > > No it does not raise an error. IB does allow ambiguous SQL statements. > > That is weird. It appears to use the fields from the "joined to" table > (TCOSTO in Sergio's case). Is InterBase supposed to behave this way? I > wouldn't think this behaviour is very SQL compliant. I wish it would raise an error but it does not. So it's good advice to always qualify field names with the table or table alias as an ambiguous reference can result in incorrect results. -- Wayne Niddery (Logic Fundamentals, Inc.) RADBooks: http://www.logicfundamentals.com/RADBooks/delphibooks.html It used to be that other people's achievements were considered an inspiration, not a grievance.
Technical Details
Message-ID:
<3df81867@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3df789da@newsgroups.borland.com> <3df78f42$1@newsgroups.borland.com> <3DF79889.478716CE@mindspring.com> <3df7a06e$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 114a0e,809958e3ec144d77 X-Google-Attributes: gid114a0e,public X-Google-ArrivalTime: 2002-12-11 21:09:24 PST From: "Wayne Niddery [TeamB]" <wniddery@chaff.aci.on.ca> Newsgroups: borland.public.interbase.sql References: <3df789da@newsgroups.borland.com> <3df78f42$1@newsgroups.borland.com> <3DF79889.478716CE@mindspring.com> <3df7a06e$1@newsgroups.borland.com> Subject: Re: left join in TIBDataSet Date: Thu, 12 Dec 2002 00:00:02 -0500 Lines: 20 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 NNTP-Posting-Host: 209.50.82.158 Message-ID: <3df81867@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1039669351 209.50.82.158 (11 Dec 2002 21:02:31 -0800) X-Authenticated-User: wniddery Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail