Microsoft Azure Data Fundamentals — Question 93

Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?

Answer options

• A. SET
• B. VALUES
• C. KEY
• D. JOIN

Correct answer: D

Explanation

The correct answer is D, JOIN, because it is specifically designed to combine rows from two or more tables based on a related column between them. The other options, such as SET, VALUES, and KEY, do not serve this purpose in the context of a SELECT statement.