This helped me do something like what your asking for. http://tinyurl.com/6r6z92
HTH On Fri, Jun 6, 2008 at 2:14 PM, Dawson, Michael <[EMAIL PROTECTED]> wrote: > Sorry, I thought you said "if", not "how". > > As another person suggested, you could use nested loops. Or, you could > insert into a temp SQL table and run the outer join. > > m!ke > > -----Original Message----- > From: Richard White [mailto:[EMAIL PROTECTED] > Sent: Friday, June 06, 2008 12:14 PM > To: CF-Talk > Subject: Re: left join on query of queries > > Yes we are aware that they are not supported and we are looking for a > workaround. does anyone have any suggestions? > > thansk > > >>Outer joins are not supported in QoQ. >> >>You will have to come up with a workaround. Search this list for some >>suggestions. >> >>m!ke >> >>hi, >> >>does anyone know how i can achieve a left join in a query of queries >> >>thanks >> >>richard > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306996 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
