Relationship between different databases

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hello experts

I have two tables from from two different databses. Is there any possibility of giving relationship between those two tables. Please help me.

-- Anonymous, May 31, 2004

Answers

Kalyan,

You would do it like this:

select t1.*, t2.* from DB1.dbo.TABLE1 t1 inner join DB2.dbo.TABLE2 t2 on t1.table_ID = t2.table_ID

Hope this helps,

Eric

-- Anonymous, June 07, 2004


thanks for the reply Erik,

But I am not about a join. I am asking about referential Intigrity. Is it possible?

-- Anonymous, June 10, 2004


Moderation questions? read the FAQ