This script should do it:

-- this sets up a linked server (or you can right-click "Server Objects|Linked Servers"

-- and set up the link manually using the wizard)

USE [YOUR_DATABASE]

GO

EXEC master.dbo.sp_addlinkedserver

@server = N'[LINKED_SERVER_NAME]'

,@srvproduct = N'SQL Server'

/* For security reasons the linked server remote logins password is changed with ######## */

GO

EXEC master.dbo.sp_addlinkedsrvlogin

@rmtsrvname = N'[LINKED_SERVER_NAME]'

,@useself = N'False'

,@locallogin = NULL

,@rmtuser = N'[USER_NAME]'

,@rmtpassword = '[PASSWORD]'

GO

-- Once you have the server link set up then you can connect to it

-- just like any other object but you must provide a fully qualified reference

SELECT

*

FROM

[YOUR_DATABASE].[DBO].[YOUR_TABLE] AS a

INNER JOIN

[LINKED_SERVER_NAME].[LINKED_DB_NAME].[DBO].[LINKED_TABLE] AS b

ON a.ID = b.ID