hi, all
i have 2 tables,. same structure, but the location of the each table is different
below is the query (if same server)
Code:
SELECT db1.dbo.table1.field_id,db2.dbo.table2.field_name
FROM db1.dbo.table1 INNER JOIN
db1.dbo.table2 ON db1.dbo.table1 = db1.dbo.table2
the problem is the server is different computer, different IP and different authentication..how to i join that tables ?
need help.
thank's
Jigujigu