No, not two datasources as they are defined in CF, but, you can use a database link depending on your database. In Oracle a database link is pretty easy to create (no documentation here or I'd look it up). Once you have created it you refer to it in the following fashion: select x.field1, y.field2 from mylocaltable x, myremotetable@mydblink y where x.pk = y.fk In Access I believe I've seen on this list that you can refer to the second database using it's physical file location. Sorry, I don't remember the code! Hopefully Michael's archive will be up soon . . . :) Dan -----Original Message----- From: James To: [EMAIL PROTECTED] Sent: 7/17/2000 7:25 AM Subject: linking tables in from two different datasource Is it possible to link two tables together in a cfquery that are located in two different datasource? Can you please sure the code? Thanks James ------------------------------------------------------------------------ ------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
