ColdFusion does not support OUTER JOIN or INNER JOIN syntax, as the following example shows it does however support INNER JOINs between two tables :
SELECT product_ID, shipping_ID FROM product, shipping WHERE product.product_ID = shipping.shipping_ID -----Original Message----- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 15:52 To: CF-Talk Subject: QofQ Joins Is it possible to do an outer join in a query of queries? I can't find any good documentation that explains QofQ's capabilities/limitations. It seems to support inner joins, but I haven't come up with an outer join syntax that doesn't throw an error. Thanks, - Sean ~~~~~~~~~~~~~~~~~~~~~~~~~~ Sean Daniels Director of Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~~~~~~~~~~~~~~~~~~~~~~~~~ http://www.dealforce.com http://www.mergernetwork.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4