Should be able to. Reference the fields like so:
SELECT dt.fieldname
FROM database1.table1 d1t1
INNER JOIN database2.table1 d2t1
ON d2t1.id = d2t1.id
<!----------------//------
andy matthews
web developer
certified advanced coldfusion programmer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--------------//--------->
-----Original Message-----
From: Tim Claremont [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 28, 2006 11:15 AM
To: CF-Talk
Subject: Inner Join Across Two Data Sources?
I have two databases. One is in SQL Server, and the other is in FoxPro.
Can I perform a single CFQUERY that includes one table in each data source
and joins the two based on say... ClientNum?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254650
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
