(Access)When implementing a hierarchical report involving two tables in a 1-M relationship,a SQL query using a join on the 1-table and the M-table is formulated,but the linking column is not identified in the query.

Question

Quizplus · Accepted Answer

The linking column needs to be identified in the JOIN clause of the SQL query to properly link the two tables and generate the hierarchical report. Without specifying the linking column, the query would not be able to join the two tables and the report would not be generated correctly.

(Access)When Implementing a Hierarchical Report Involving Two Tables in a 1-M