I think he sorted it, that will work for the same DB instance/type but for X-Server joins you will need to use Linked Servers.
-----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: 06 September 2006 14:19 To: CF-Talk Subject: RE: Cross-Server Joins Using mySQL it's possible (as long as the user you're logged in as has permissions on both tables. Simply prepend the tablename with the database name like so: SELECT d1t1.id, d2t2.id FROM database1.table1 AS d1t1 INNER JOIN database2.table2 AS d2t2 ON d1t1.id = d2.t2.id <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 3:59 AM To: CF-Talk Subject: Cross-Server Joins I have heard tell that it is possible to perform cross-database and even cross-server joins in MSSQL but I can't find any good info on how it is done. Can someone point me in the right direction, specifically for the cross server stuff? -- Jay ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252209 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
