Php combined with ACCESS's cross-database query function

Sometimes we can use access when developing a small program or a simple function management system without a mysql database, in addition, you can use the cross-database query function of ACCESS to implement problem description in two or three database tables: sometimes you need to use related keywords in two or three database tables, query to obtain the required record set, which cannot be achieved using common SQL query statements, can be achieved through 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:

The code 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.

The above is all the content of this article. I hope you will like it.