Mind if i ask why? Seems to me a one-query union would be faster than anything CF could do that would require TWO queries, on top of the extra CF processing.
----- Original Message ----- From: "David Mineer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, October 20, 2004 1:34 PM Subject: Add the results of one query to another > What is the best way to add the results of 2 queries into one. > > I want to check 2 different databases for login information. A union > query does work but I would like to use Cold Fusion to do it if > possible. > > TIA, > > -- > David Mineer Jr > > --------------------- > Don't wish it was easier; wish you were better. > Don't wish for less problems; wish for more skills. > Don't wish for less challenges; wish for more wisdom. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.houseoffusion.com/banners/view.cfm?bannerid=39 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182060 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54