Thanks, but that is not what I am asking. The queries have multiple tables combined with the UNION command.
I can't get all of the data from one query. I have to create a query to get the child/parent relationship and then use another query to extract record info. Bob On Fri, 30 Mar 2007 17:28:04 +0200, "Jochem van Dieten" <[EMAIL PROTECTED]> said: > 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:274208 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
