Thanks, I was afraid that I was going to have to do a QofQ. I guess I'll start work on that solution.
Thanks again, - Charles On May 23, 2006, at 10:47 AM, Ken Ferguson wrote: > 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:241243 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
