You first link your server and give it a name. The name is arbitrary, but should be meaningful.
Then, a query would look like SELECT * FROM Database.dbo.Table A JOIN MyLinkedServer.Database.dbo.Table B ON A.id = B.id No need to specify the linked server name for the "local" server or the server that is referenced in your datasource. mike -----Original Message----- From: Chad Gray [mailto:[email protected]] Sent: Friday, January 16, 2009 8:23 AM To: cf-talk Subject: RE: join two databases Ah.. so there is a way in MS SQL to link two servers together. Then I would just add one DSN in CF Admin. How do you write your SQL in CFQuery? SELECT * FROM server1.database1.table1 AS a JOIN server2.database2.table2 AS b on b.index = a.index Thanks, I will go read up on linking two servers. Chad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:318071 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
