I was going to suggest a union, so that link you found is the way to go IMO.
On 8/18/06, Roberto Perez <[EMAIL PROTECTED]> wrote: > I found a link to a "fake left outer join" script at > http://instantbadger.blogspot.com/2006/07/faking-left-outer-join-in-query-of.html > > A left outer join sound just like what I need to do. Is there an > easier way to do it (easier than what is described in the link above)? -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250279 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4