look up "query of query". If you have a query result named foo and
one named goo, you can use
<cfquery name="foogoo" dbtype="query">
SELECT foo.username, goo.somecolumn
FROM foo, goo
WHERE foo.id = goo.id
</cfquery>
Doug
On Wed, 20 Oct 2004 12:34:46 -0600, David Mineer <[EMAIL PROTECTED]> wrote:
> 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.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the mailserver that powers this list at
http://www.houseoffusion.com/banners/view.cfm?bannerid=17
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182061
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
