DB Relationship

[guymanager]

Hi,

How to make a relationship between two Databases ? For ex :

DBName : DB1
TableName: tblPrj
FieldName: Prjcode

DBName : DB2
TableName: prjAccts
FieldName: prjcode

Now is there any posibilities that i can make a relationship between the two databases referencing the field PrjCode , pls guide me if any one have idea abt this.

Thanks,
guymanager.

 

[snag56]

Assuming the 2 db's are on the same SQL server:

select P.Prjcode, A.prjcode
from DB1..tblPrj P
inner join DB2..prjAccts A
on P.Prjcode = A.prjcode