ACCESS requires the use of parenthesis to do multiple outer joins...
SELECT c.itemID, c.title, c.ownerID, c.type, i.subject, i.intDate,
r.rvwType
FROM (( content c LEFT OUTER JOIN interviews i
ON c.itemID = i.itemID)
LEFT OUTER JOIN reviews r
ON c.itemID = r.itemID)
WHERE c.activated = 1
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
"Let's Roll"
- Todd Beamer, Flight 93
-----Original Message-----
From: Gyrus [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 11:43 AM
To: CF-Talk
Subject: Re: multiple OUTER joins in SQL?
----- Original Message -----
From: "Dina Hess" <[EMAIL PROTECTED]>
> Try this:
>
> SELECT c.itemID,
> c.title,
> c.ownerID,
> c.type,
> i.subject,
> i.intDate,
> r.rvwType
> FROM content c LEFT JOIN interviews i ON c.itemID =
> i.itemID
> LEFT JOIN reviews r ON c.itemID = r.itemID
> WHERE c.activated = 1
----------------------------
Afraid not - I get "Syntax error (missing operator)" for the WHERE
statement. I'm using Access 2000 - is this the problem? Maybe it can't
handle multiple outer joins?
Thanks anyways,
- Gyrus
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
