I'm pretty sure that an outer join expects to find two 'tables' to work with. The QofQ returns a singular result set (probably viewed by CF as a single table). So, in theory, an outer join wouldn't work on a OofQ.
thanx Denny -----Original Message----- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 8:52 AM 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
