Yea, in DB2 you can just do SELECT col1, col2, col3 FROM file
UNION ALL SELECT col1, col2, col3 FROM file2 ORDER BY col1 Note the order by goes after all your UNION's, and sorts the entire result set. Chris -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, March 30, 2007 11:28 AM To: CF-Talk Subject: Re: Multiple Query Totals Bob Johnson wrote: > > How to I take two queries and combine them so they paging will work? Check your database manual for UNION. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274205 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
