Hi Nathan, Both cf8 and cf9 allow for left outer joins when doing normal queries however as far as I know query of query's does not support joins.
On a side note though, my general rule of thumb is if I need to use a query of queries for anything other than changing the order of my structure, than I really need to evaluate my original SQL query and looped query of queries are big programming no no. Just my 2 cents.. : ) Paul Alkema http://paulalkema.com/ -----Original Message----- From: Nathan Chen [mailto:[email protected]] Sent: Monday, October 25, 2010 1:53 PM To: cf-talk Subject: left outer join in query of query All: I am on CF 8 now. Does anyone know if CF 9 supports left outer join in query of query? CF 8 doesn't allow left outer join. Nathan Chen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
