Article View: borland.public.interbase.sql
Article #11220Re: left join in TIBDataSet
From: Brian Cook
Date: Wed, 11 Dec 2002 20:30
Date: Wed, 11 Dec 2002 20:30
7 lines
1628 bytes
1628 bytes
> 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. - Brian
Technical Details
Message-ID:
<3df7a06e$1@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-08!supernews.com!38.144.126.70.MISMATCH!feed3.newsreader.com!newsreader.com!news-xfer.cox.net!news.stealth.net!news.stealth.net!fr.usenet-edu.net!usenet-edu.net!proxad.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer00.lnd.ops.eu.uu.net!emea.uu.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>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 12:39:56 PST Reply-To: "Brian Cook" <bcook@rowdydogsoftware[REMOVE].com> From: "Brian Cook" <bcook@rowdydogsoftware[REMOVE].com> Newsgroups: borland.public.interbase.sql References: <3df789da@newsgroups.borland.com> <3df78f42$1@newsgroups.borland.com> <3DF79889.478716CE@mindspring.com> Subject: Re: left join in TIBDataSet Date: Wed, 11 Dec 2002 14:30:40 -0600 Lines: 10 Organization: Rowdy Dog Software X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 NNTP-Posting-Host: 63.99.201.46 Message-ID: <3df7a06e$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1039638638 63.99.201.46 (11 Dec 2002 12:30:38 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!38.144.126.70.MISMATCH!feed3.newsreader.com!newsreader.com!news-xfer.cox.net!news.stealth.net!news.stealth.net!fr.usenet-edu.net!usenet-edu.net!proxad.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer00.lnd.ops.eu.uu.net!emea.uu.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail