Which clause lists the tables that contain the fields in the SELECT clause?

• A. Group By
• B. From
• C. Having
• D. Where

Answer: (B)

The main idea here is how SQL knows where the data for the selected columns comes from. The SELECT clause chooses which fields to display, but those fields come from tables, so the clause that lists those tables (and how they’re connected) is the FROM clause. The FROM section names the source tables and, when needed, sets up joins between them. You can also use table aliases to simplify references like table_alias.column_name. The other clauses serve different roles: WHERE filters rows before grouping; GROUP BY organizes rows into groups for aggregation; HAVING filters those groups after aggregation. So listing the tables that contain the fields in the SELECT clause is done in the FROM clause.