Re: Multiple Joining

Article View: borland.public.cppbuilder.database.ado

Article #2767

Back to borland.public.cppbuilder.database.ado Previous Next

#2767

From: Mike Crapo
Date: Wed, 02 Apr 2003 17:21

30 lines
1617 bytes

Sure

SELECT a.*, b.Name, c.Whatever, d*
FROM ((a LEFT JOIN b ON a.this = b.this)
LEFT JOIN c ON a.that = c.that) 
LEFT JOIN d ON a.Whatever = d.Whatever
WHERE a.ID = 1

Notice the brackets around the joins.  That is what you need to pay
attention to.

Mike

On Tue, 1 Apr 2003 20:56:35 -0800, "Richard Lauren"
<richardmlauren@yahoo.com> wrote:

>Hi,
>
>Can anybody show me some codes on multiple join? I need to do multiple join
>for tables A, B, and C (or even more) and tried something like,
>
>Select A.a1, B.b1, C.c1 from A inner join B on A.id_a = B.id_b left outer
>join C on A.id_a = C.id_c   (and may do more join here)
>
>Any ideas?
>
>Richard
>
>
>

Technical Details

Message-ID: <no6m8v0lt9lv1gn39vdrdsd08nm0nq576l@4ax.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!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <3e8a6cfe$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,ecf72129f668be7f
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-04-02 09:25:25 PST
From: Mike Crapo <>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: Multiple Joining
Date: Wed, 02 Apr 2003 11:21:38 -0600
Message-ID: <no6m8v0lt9lv1gn39vdrdsd08nm0nq576l@4ax.com>
References: <3e8a6cfe$1@newsgroups.borland.com>
X-Newsreader: Forte Agent 1.92/32.572
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 208.178.101.226
X-Trace: newsgroups.borland.com 1049304208 208.178.101.226 (2 Apr 2003 09:23:28 -0800)
Lines: 31
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!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message