----- 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
