Tuesday, 4 November 2014

join tables in two different databases in sql server

SELECT [database 1].[owner].[table name].[field name],
[database 2].[owner].[table name].[field name]
FROM [database 1].[owner].[table name] INNER JOIN [database 2].[owner].[table name]
ON [database 1].[owner].[table name].[field name] = [database 2].[owner].[table name].[field name]

No comments:

Post a Comment

Working with 3- Tier Architecture in C#

  Introduction In this article we will learn Use to 3- Tier architecture in C#.NET application. 3-Tier architecture is very famous and ...