Database subqueries and paged queries

Two tables need to be established when creating a subquery

How to establish an association

The association needs to be associated after the table is created.

Right-click the table you want to associate, select design, and the design interface appears (bottom right)

Click Add, then click on table and column specifications, the "..." option appears, click to select

Open the interface such as, set the primary key table for Bumen in the Bcode foreign key table for Renyuan Bumen

Querying, subqueries, and paging queries

Paging Query

Determine the number of pages to be divided according to the existing information

After a relationship is established, the statement is automatically terminated if information other than the primary key is added

1009 is not in Bumen's Bcode column, so abort execution

Database subqueries and paged queries