Off the top of my head... You can use a SQL UNION statement http://www.coldfusionmuse.com/index.cfm/2005/7/25/union%20queries
Or you can take the results of your two queries and use Query of a query to perform a SQL UNION with the two queries. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=using_recordsets_7.html HTH G! On Wed, Feb 10, 2010 at 11:23 AM, Alan Rother <alan.rot...@gmail.com> wrote: > > Hey Patrick, > > Not knowing anything about the database server type, table structures, > current queries, data types or end use goals it's very hard to make > any recommendations. It's like asking someone, "what's the best way to get > here" and not sharing the starting or ending points or how you want to get > there (car, boat, plane, bike, walk). > > To help you out you're going to need to provide more details about the > specifics. > > =] > > -- > Alan Rother > Adobe Certified Advanced ColdFusion MX 7 Developer > Manager, Phoenix Cold Fusion User Group, AZCFUG.org > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330552 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4