> What is the best way to join tables across two databases servers? > > Say I have one MS SQL server that has a database that stores ERP product > data. I have our website MS SQL server that stores extra data about the > product records in the ERP database. > > Is it possible to hook each datasource up in CF Admin and use both DSN's in > the same CFQuery? > > Or should you do something on the MS SQL servers to join them then hook up > one datasource in CF Admin?
I'm pretty sure you're going to have to do two separate queries and the do a Query of Queries to tie the two together. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318063 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
