Join Query

[murugavelmsc]

hi,

in sql server,
i want to join two table in different server using join query.
guide me

thanks,
murugavel

[deepuv04]

Hi,

If you want to retrieve data from another server or remote server, you need to add it to linked servers. Then only you can retrieve the data from that server,

use the following code:

[code= sql]

USE MASTER
GO
EXEC master.dbo.sp_a ddlinkedserver
@server = 'SERVER_NAME', --This is an ODBC connection that is setup on the machine.
@srvproduct = '',
@provider = 'SQLNCLI',
@datasrc = 'SERVER_NAME',
@catalog = 'DATABASE_NAME'
go
EXEC master.dbo.sp_a ddlinkedsrvlogi n
@rmtsrvname=N'S ERVER_NAME',
@useself=N'Fals e',
@locallogin=NUL L,
@rmtuser=N'USER _NAME',
@rmtpassword='P ASSWORD'

go


SELECT *
FROM OpenQuery([SERVER_NAME], 'select * from Table_Name') AS T1 INNER JOIN
Table_Name AS T2 ON T1.Column_Name = T2.Column_Name

[/code]

Thanks