Re: Trouble with left outer joins

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

Article #4469

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

#4469

From: Jakob Petersen
Date: Wed, 02 Jan 2002 12:55

30 lines
1680 bytes

Hi David,

Try

Select CAT.NAME, CAT.ID, MAK.CAT_ID, MOD.CAT_ID
FROM ((CAT LEFT OUTER JOIN MAK ON MAK.CAT_ID = CAT.ID)
LEFT OUTER JOIN MOD ON MOD.CAT_ID = CAT.ID)

Best regards,

Jakob Petersen
Microhouse

"David Barnes" <david@kalos-inc.com> skrev i en meddelelse
news:3C332A85.5080001@kalos-inc.com...
> I am abit new to the world of ADO so I think this is more of a syntax
> question, but here it goes.
>
> I want to run a statement similar to this:
>
> Tables: CAT (Catagory), MAK (Brand), MOD (Model)
>
> "Select CAT.NAME, CAT.ID, MAK.CAT_ID, MOD.CAT_ID FROM CAT "
> "LEFT OUTER JOIN MAK ON (MAK.CAT_ID = CAT.ID)"
> "LEFT OUTER JOIN MOD ON (MOD.CAT_ID = CAT.ID)"
>
> I can get a single LOJ to work, but whenever I add the second, I get
> errors.
>
>

Technical Details

Message-ID: <3c36f89d_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-03!supernews.com!news-out.visi.com!hermes.visi.com!hub.org!hub.org!PeerFeed.KWeb.on.ca!KWeb!dnews

References: <3C332A85.5080001@kalos-inc.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,4d0fe284ff6f2e77
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-01-05 05:12:54 PST
From: "Jakob Petersen" <Jakob@microhouse.dk>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3C332A85.5080001@kalos-inc.com>
Subject: Re: Trouble with left outer joins
Date: Wed, 2 Jan 2002 13:55:48 +0100
Lines: 32
Organization: Microhouse Aps
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: 130.228.39.86
Message-ID: <3c36f89d_2@dnews>
X-Trace: dnews 1010235549 130.228.39.86 (5 Jan 2002 04:59:09 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-03!supernews.com!news-out.visi.com!hermes.visi.com!hub.org!hub.org!PeerFeed.KWeb.on.ca!KWeb!dnews

Reply to Parent Message