Which type of query should be used to select fields from one or more related tables in a database?

A Simple query selects specified fields from one or more tables, including related tables, and displays the matching records. A Crosstab query summarizes data in a row-and-column layout, while Find duplicates looks for repeated values. An Outer Join is a way to combine table records, not the query type described.

AI-written and checked against the verified answer.