>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. >
I found this article to be extremely helpful when dealing with QoQs (watch for wrapping): <http://www.daemon.com.au/index.cfm?objectid=64307CBB-D0B7-4CD6-F9A4C292986B884F> Number 9 in his list should answer your question for you. Incidentally, I found Daemon's entire "Tips and Tricks" section of their site to be quite helpful. Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
