Multidatabase Query

[GDX]

Hello I am trying to connect two tables together from two diffrent MSSQL Databases on the same box. Is this possible through a query or do i have to write a VBScript to perform a compare on the two tables?


Thanks,
Gordon

Gordon R. Durgha
gd@vslink.net

http://www.vslink.net

http://www.brainbench.com/transcript.jsp?pid=1217371

 

[MikeWiz9]

You can do this by fully qualifying the query.

eg.
SELECT *
FROM Database1.owner.tableA A
INNER JOIN Database2.owner.tableB B
ON A.field1 = B.field2

 

[GDX]

Thanks a lot Mike that was easy enough i was actually thinking about trying something like that also.

Thanks again,
Gordon

Gordon R. Durgha
gd@vslink.net

http://www.vslink.net

http://www.brainbench.com/transcript.jsp?pid=1217371