Adam Parker wrote: > Would this be accomplished using a SQL Union or a query of queries?
I've never tries to use queries of queries against two result sets at the same time, so I don't know if that will work. You can't do the union within the same SQL query though against two different datasources. You can also use looping in conjunction with the query manipulation functions (queryAddRow and querySetCell) to manually append rows to a result set though, copying data from another. That's not ideal, but if you really need them to be in the same query variable it'll do in a pinch. -Justin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4417 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
