Trouble with left outer joins

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

Article #4452

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

#4452

From: David Barnes
Date: Wed, 02 Jan 2002 15:43

13 lines
1327 bytes

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: <3C332A85.5080001@kalos-inc.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!KWeb!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,4d0fe284ff6f2e77,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-01-02 07:46:21 PST
Message-ID: <3C332A85.5080001@kalos-inc.com>
Date: Wed, 02 Jan 2002 09:43:01 -0600
From: David Barnes <david@kalos-inc.com>
User-Agent: Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:0.9.4) Gecko/20011019 Netscape6/6.2
X-Accept-Language: en-us
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Trouble with left outer joins
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 65.69.231.139
X-Trace: dnews 1009986182 65.69.231.139 (2 Jan 2002 07:43:02 -0800)
Lines: 15
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!KWeb!dnews