You can query multiple databases as long as you have permissions on both. In
mySQL you prepend the table name with the database name like so:
SELECT d1_t1.listing_id, d1_t1.listing_mlsnumber,d1_t1.listing_type,
d2_t4.pLisPric
FROM databasename_01.table_01 d1_t1
INNER JOIN databasename_02.table_04 d2_t4
ON d2_t4.pMlsNum = d1_t1.listing_mlsnumber
<!----------------//------
andy matthews
web developer
certified advanced coldfusion programmer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--------------//--------->
-----Original Message-----
From: Charles E. Heizer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 23, 2006 12:13 PM
To: CF-Talk
Subject: Query Multiple Datasources...
Hello,
I was wondering if and how I could query multiple datasources,
essentially a simple join on two different datasources? I have tables
in Oracle and MySQL databases and I want to query info from both for
a return set.
Thanks,
- Charles
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241238
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
