Inner join on 2 different Databases

[hooks]

Does anyone know how to do a join on 2 mssql tables that are in 2 different mssql databases????

SELECT Table1.ID, Table1.PrjID, Table1.Description, Table1.Order, Table1.Csr_ID, Table1.Resource, Table1.SDate, Table1.CreateDate, Table1.PromisedDate, Table1.Hours, Table2.creation_date
FROM Table1 LEFT JOIN Table2 ON Table1.ID = Table2.cID;

I have 2 different MSSQL databases on 2 different servers that i need to join

Table1 on one server
Table 2 on the other

thanks Hooks

 

[SQL_Hell]

Hi

you need to set up a linked server, have you done that yet?

 

[hooks]

I am unable to create a linked server.

I have found another solution. I am just using multiple select statements. Not the best solution but it works in this case.

Thanks Hooks