But, Charles wants to query multiple DATASOURCES, not just multiple databases. I think the best way for you to get this done Charles is with a QofQ, as Charlie G. suggested. You'll need to make each of your queries and then use a query to join the recordsets.
--Ferg Andy Matthews wrote: > 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:241241 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
