The FROM clause for your Access query should probably look something like this:
reviews r LEFT JOIN (content c LEFT JOIN interviews i ON c.itemID = i.itemID) r.itemID = c.itemID If you have Access on your laptop, the easiest way to check the syntax is to use the Access query-by-design feature: Click 'Queries' under 'Objects' then click 'Create query in design view.' You can select tables to use in your query then drag fields into the corresponding grid. Table relationships for the query can be defined right there and when you get it all in place, just switch to View | SQL View and copy/paste. ----- Original Message ----- From: "Gyrus" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, September 20, 2002 1:43 PM 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
