Well, these two queries usually server two different purposes and I need them combined only in this situation. There will be times where I will want to use the two queries individually, so Instead of having 3 queries, each one individually plus the union I would rather just have two and combine them in the one case.
I understand query of queries a little , but in this case I don't see how they would work. The example was given to join them based on a common id, but there will be no common id. I thought of qofq but... WIll it work in this case. Hope I am clear. Not a huge deal, just trying to be as OO as I can. Thanks for your input. On Wed, 20 Oct 2004 13:40:30 -0500, G <[EMAIL PROTECTED]> wrote: > 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. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182132 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54