Question

A select query (Please explain your choice)

1. displays other queries
2. displays specific fields from multiple tables which match certain criteria
3. selects hidden records and displays their form
4. displays relationships

Answer 1

1. displays specific fields from multiple tables which match certain criteria
   

A select query contains 2 clause atleast: Select field Clause, From Table Clause... Along with this, there is a where clause and group by clause also in some cases..

So, A select query basically joins multiple tables together, and then based on matching logic and filter criteria, It selects specific rows.. from each row, it shows the fields which are selected in select list.