Thanks everyone. I misunderstood the last "UNION" post. The UNION ALL is working perfectly.
Thanks for helping me out. Bob On Fri, 30 Mar 2007 11:30:55 -0400, "Peterson, Chris" <[EMAIL PROTECTED]> said: > 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 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274211 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
