In this case, perhaps:
<cfquery name="foogoo" dbtype="query">
SELECT col1,
col2,
col3
FROM foo
UNION
SELECT col1,
col2,
col3
FROM goo
</cfquery>
> -----Original Message-----
> From: Douglas Knudsen [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 21 October 2004 7:43 a.m.
> To: CF-Talk
> Subject: Re: Add the results of one query to another
>
> 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.
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182134
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
