Use OpenDataSource in the SQL query statement Select to connect the database on another server, such as:
Select a. *, b. * from table1 a inner Join (OpenDataSource ('sqloledb', 'data source = server name; user ID = sa; password = password'). Database .dbo.table2 b on A.f1 = B .f1
example:
Select a. *, b. * from bm a inner Join OpenDataSource ('sqloledb', 'data source = 192.168.1.201; user ID = pk; password = 2332'). Dorich2000.dbo.bm b on A.Bmmc = B .bmmc
