Running query with 2 datasources

[_aggregate]

I have two databases that I need to pull data from. One database is
application data the other has user info. The application data base has a list
of userID that have access to applications. The other one has a user table
with userID, first name & Last name. I'm trying to list all the users that has
access to application. I can do the userID but I need to display the Name of
the user.

This displays the userID
<cfquery name="qry_ListUserToApp" datasource="Ai_database">
SELECT
CA.ID,
CA.ApplicationID,
CA.Name,
CA.Path,
CA.Path1,
AU.UserID
FROM
dbo.CMS_Applications CA,
dbo.AI_UserPermission AU
WHERE
(AU.ApplicationID = CA.ApplicationID)
AND
('#url.AppID#' = CA.ApplicationID)
</cfquery>

This shows users Name

<cfquery name="qry_ListICUsers" datasource="SQLSecurity">
SELECT FirstName,LastName, username, UserID
FROM Intranetconnections.UserProfiles
Order by LastName
</cfquery>

How do I combine the two?

Any help will be great. I have a deadline of tomorrow Thanks in advanced

[mxstu]

What database are you using? Are these databases on the same server? Can you
just execute a query across the databases? For example, in SQL Server, with
the appropriate permissions:

SELECT t1.Column1, t2.Column2
FROM database1.dbo.SomeTable t1, database2.dbo.SomeOtherTable t2
......

[mxstu]

There are probably a number of posts on this topic. [url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=7&threadid=1008384[/url] offers a few possibilities.