Hi,

You must miss something simple. I don't know your exact code, however put attention on data types in tables of both databases.

select col1,col2,...,colN

from db1.shcema1.table1 tb1

join db2.schema2.table2 tb2 on convert(nvarchar(100), tb1.id) = convert(nvarchar(100),tb2.id)

where ... 'your conditions'

also check if the collations on both databases are same.

🙂