PHP combines ACCESS's cross-database query function_PHP tutorial

php combines the cross-database query function of ACCESS

Problem description: Sometimes it is necessary to query and obtain the required record set through related keywords in the tables of two or three databases. , which cannot be achieved with ordinary SQL query statements, can be achieved through the cross-database query function of ACCESS.

Solution: For example, the two tables "Content Type" and "Content Material" are in different databases. The specific query method is as follows:

The code is as follows:

@"Select * from loading material type as a INNER JOIN [;database=" AppDomain.CurrentDomain.BaseDirectory "loading material.zc]. loading material as b ON a.BH=b.LXBH"

Detailed explanation: [;database=path;pwd=12].A

ACCESS's cross-library is implemented through square brackets, including path, password settings, etc.; the premise of cross-library is that a Connection has been opened.

http://www.bkjia.com/PHPjc/1015877.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1015877.htmlTechArticlePHP combined with ACCESS’s cross-database query function Description of the problem: Sometimes it is necessary to use tables in two or three databases. Query to obtain the required record set through related keywords, and use general SQL query statements...