Problem Description: Sometimes need in two or three database tables, through the relevant keywords, query to obtain the required recordset, with a general SQL query statement is not achievable, through access to the cross-Library query function.
Solution: For example, "Loading type" and "material" two tables are in different databases, the specific query method, as follows:
@ "SELECT * from" Loading type as a INNER JOIN [;d atabase= "AppDomain.CurrentDomain.BaseDirectory" loading material. Zc]. Loading as B on A.bh=b.lxbh "
Detailed explanation: [;d atabase=path;pwd=12]. A
Access's cross libraries are implemented through brackets, including paths, password settings, and so on, as long as a connection is already open across the library.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
