i am trying to figure out the syntax to do a SQL inner join from 2 different databases...
The sameple code looks like this: select *
from database1.dbo.table1 t1 join database2.dbo.table2 t2 on
t1.field1 = t2.field2
but I dont know how to refernce the " database1.dbo" and "database2.dbo" parts.. can someone help?
i know the table names in all my databases.. i have the connections in include files..
i just dont see how to "call" the other database? basically what i to know is what need to change dqatabase1, database 2, and dbo to in my code?