On Tue, 30 Nov 2004 11:46:23 -0400, Meg Briggs <[EMAIL PROTECTED]> wrote: > I need to basically do a left join, but the information I have found so far > says this isn't > possible in query of queries in ColdFusion.
I've run into this issue myself and the best thing I can suggest to do is use a CFScript block to mimic the left outer join concept. You'll need to do a nested loop, first looping through the primary query and then through the secondary query to check the match. If you need an example let me know and I'll try to grab up some code. Hatton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:15:516 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
