Re: left join in TIBDataSet

Article View: borland.public.interbase.sql

Article #11219

Back to borland.public.interbase.sql Previous Next

#11219

From: Jeff Overcash (TeamB)
Date: Wed, 11 Dec 2002 19:56

26 lines
1960 bytes


Harun Bolat wrote:
> 
> > SELECT ID, ID_TCosto, Descripcion, Valor, Accion
> >     FROM COSTO C
> >     LEFT JOIN TCOSTO TC
> >     ON C.ID_TCOSTO = TC.ID_TCOSTO
> >     WHERE C.ID = :ID
> > 1) I didn't specify in which table is each field. Should I?
> 
> yes but all field that you select have to belong only one table. for example
> if ID_TCOSTA field found COSTA and TCOSTO tables , select statement raise
> error.
> 

No it does not raise an error.  IB does allow ambiguous SQL statements.

-- 
Jeff Overcash (TeamB) 
      (Please do not email me directly unless  asked. Thank You) 
Maybe it was infatuation or the thrill of the chase.
Maybe you were always beyond my reach and my heart was playing safe.
But was that love in your eye I saw or the reflection of mine?
Give me time, won't you give me that time!
Welcome back to the circus.            (Fish)

Technical Details

Message-ID: <3DF79889.478716CE@mindspring.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!news-hub.siol.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3df789da@newsgroups.borland.com> <3df78f42$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 12:12:03 PST
Message-ID: <3DF79889.478716CE@mindspring.com>
Date: Wed, 11 Dec 2002 14:56:57 -0500
From: "Jeff Overcash (TeamB)" <jeffovercash@mindspring.com>
Organization: TeamB
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: left join in TIBDataSet
References: <3df789da@newsgroups.borland.com> <3df78f42$1@newsgroups.borland.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 66.32.68.81
X-Trace: newsgroups.borland.com 1039636456 66.32.68.81 (11 Dec 2002 11:54:16 -0800)
Lines: 26
X-Authenticated-User: overcash
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!news-hub.siol.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message