var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Join between tables on different databases
Is it possible to make a join between two tables from different databases on same server? if yes, how can we do that?
And also if I want to make a join between tables on different databases on different server?how to do this. Please advise.
SELECT Customers.CustomerID, Cst.FirstName, Cst.LastName
FROM Northwind.dbo.Customers AS Cst
You could use 'full' name of tables.
For tables on different dbs on different servers, you have to set up linked servers and use the FQDN (four part name convention) to refer to the talbes. Take a look at sp_addlinkedserver in BOL.