Links between 2 databases on the same SQL server

[nixo]

hello,

I look for establish between 2 databases on the same SQL server in a query ?

How can I do this ?

Thanks,
Nixo

[Ivo]

Hello Nixo,
Suppose you have database D1 and table T1 and database D2 and table T2.
Suppose there is a column ID in T1 and T2
Your query to join them will look :
SELECT COUNT(*)
FROM D1..T1 a, D2..T2 b
WHERE a.ID = b.ID

That's all
P.S.: there are two dots in D1..T1 - complete naming is <database>.<owner of object>.<object name>


------------
nixo at 8/7/01 5:54:12 AM

hello,

I look for establish between 2 databases on the same SQL server in a query ?

How can I do this ?

Thanks,
Nixo