Relationship between different databasesgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
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
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,
-- 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