Access problem description: sometimes it is necessary to obtain the required record set through related keywords in two or three database tables, which cannot be achieved using general SQL query statements, you can use the cross-database query function of ACCESS. Solution: for example, the "material loading type" and "material loading" tables are in different databases. the specific query method is as follows: @ Select * from material loading type asaINNERJOIN [; databaseAppDomain. cu Access
Problem Description: sometimes it is necessary to obtain the required record set through related keywords in two or three database tables, which cannot be achieved using general SQL query statements, you can use the cross-database query function of ACCESS.
Solution: for example, the "material loading type" and "material loading" tables are in different databases. the specific query method is as follows:
@ "Select * from assembly type as a inner join [; database =" AppDomain. currentDomain. baseDirectory "installation. zc]. as B ON. BH = B. LXBH"
Explanation: [; database = path; pwd = 12].
Cross-database ACCESS is implemented through brackets, including Path and password settings. the cross-database Connection is enabled on the premise that a Connection is enabled.
