Php combined with ACCESS cross-database query function _ PHP Tutorial

Php integrates the cross-database query function of ACCESS. Description of the cross-database query function of php and ACCESS: sometimes it is necessary to query and obtain the required record set in two or three database tables using related keywords, use the common SQL query statement php in combination with the cross-database query function of 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:

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.

Explain problem description: sometimes it is necessary to query and obtain the required record set in two or three database tables by using related keywords. the general SQL query statement is used...