Article View: comp.lang.pascal.delphi.databases
Article #200Re: There must be a way..
From: Ed Edwards, Jr.
Date: Wed, 16 Oct 2002 00:11
Date: Wed, 16 Oct 2002 00:11
17 lines
1517 bytes
1517 bytes
This did seem simple at first, but I can't find an SQL statement that will
do it all in one shot.
The best I could come up with was:
Create a temp table containing all the fields from TableA and TableB and
then - insert into TableTemp select * from TableA, TableB
Then -
select AName, BDate, CValue
from TableTemp left join TableC
on (TableA.Akey = TableC.Akey) and
(TableB.Bkey = TableC.Bkey)
I WOULD have expected a better way!
Ed
Technical Details
Message-ID:
<aoi09v$qk1$1@bob.news.rcn.net>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!bloom-beacon.mit.edu!news-out.cwix.com!newsfeed.cwix.com!feed2.news.rcn.net!feed1.news.rcn.net!rcn!not-for-mailReferences:
<3DAC3097.114A2197@microwaredata.co.uk>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ffff5,f8a8d7f2f6085c7b X-Google-Attributes: gidffff5,public X-Google-Thread: fb0ea,f8a8d7f2f6085c7b X-Google-Attributes: gidfb0ea,public X-Google-ArrivalTime: 2002-10-15 14:12:01 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!bloom-beacon.mit.edu!news-out.cwix.com!newsfeed.cwix.com!feed2.news.rcn.net!feed1.news.rcn.net!rcn!not-for-mail From: "Ed Edwards, Jr." <ededwards@rcn.com> Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.vcl.components.using Subject: Re: There must be a way.. Date: Tue, 15 Oct 2002 17:11:42 -0700 Lines: 19 Message-ID: <aoi09v$qk1$1@bob.news.rcn.net> References: <3DAC3097.114A2197@microwaredata.co.uk> X-Trace: UmFuZG9tSVbC81prshBDWqri4iVXbq0z8pBbftK3sl6jgQknWohFUSMfF+80b3RH X-Complaints-To: abuse@rcn.com NNTP-Posting-Date: 15 Oct 2002 21:11:27 GMT X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Priority: 3 X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MSMail-Priority: Normal