The two tables are located in different databases. How can I perform Association queries between these two databases?

The two tables are located in different databases. How do I perform Association queries between these two databases ???

From:Chinargb,Time:16:39:00,ID:2353262 please enlighten me!

From:Yq4000,Time:16:42:00,ID:2353270 select database 1. DBO. Table. *, database 2. DBO. Table. * from database 1. DBO. Table, database 2. DBO. Table

From:Xiaolinj79,Time:16:43:00,ID:2353271 data volume or server?
Data billing ticket
Select * From databasename1.dbo. Table1 as A, databasename2.dbo. Table2 as B where
A. Key = B. Key
You have to save another server to a table in the local server.
This is an example of how to check the data volume of another server in one server:
Select a. prdtcode from
OpenRowSet ('sqlodb', '192. 168.3.11 '; 'linj', 'select * From flexsideupdate. DBO. tbl_mobfilialeplan') as

From:Chinargb,Time:16:46:00,ID:2353275 but if it is two tables in different paths? What should I do?

From:Xiaolinj79,Time:16:49:00,ID:2353281 what is two tables with different channels?

From:Chinargb,Time:16:59:00,ID:2353292 I use the path name as the database name, so ....

From:Hongxing_dl,Time:17:06:00,ID:22.16304query1. databasename is set to NULL;
Query1. SQL. Text: = 'select A. field1, B. field2 from "D:/table1.dbf" A, "d:/DB/table2.dbf "'

If the alias is configured:
Query1.databasename is set to NULL;
Query1. SQL. Text: = 'select A. field1, B. field2 from ": db1: Table1" A, ": DB2: Table2 "'