Which clause is used to join tables in a query?

Which clause is used to join tables in a query?

• A. Join in the FROM clause.
• B. Join in the WHERE clause.
• C. Join is not supported between tables.
• D. Join must be performed in a separate statement.

Answer: (A)

Joining tables in SQL is done in the FROM clause using a JOIN expression to define how rows from the tables relate to each other. This approach clearly declares which tables are being combined and specifies the exact matching logic with a condition after ON, such as a.id = b.a_id. It also lets you choose the type of join (INNER, LEFT OUTER, RIGHT OUTER, CROSS) to control which rows appear in the result. Using the FROM clause for the join keeps the relationship between tables explicit and the query easier to read and maintain, while filtering conditions can go in a WHERE clause or be applied after the join. Placing join logic in the WHERE clause is an older style that can obscure the join itself, and the ideas that joins aren’t supported or must be in a separate statement aren’t correct.

Joining tables in SQL is done in the FROM clause using a JOIN expression to define how rows from the tables relate to each other. This approach clearly declares which tables are being combined and specifies the exact matching logic with a condition after ON, such as a.id = b.a_id. It also lets you choose the type of join (INNER, LEFT OUTER, RIGHT OUTER, CROSS) to control which rows appear in the result. Using the FROM clause for the join keeps the relationship between tables explicit and the query easier to read and maintain, while filtering conditions can go in a WHERE clause or be applied after the join. Placing join logic in the WHERE clause is an older style that can obscure the join itself, and the ideas that joins aren’t supported or must be in a separate statement aren’t correct.