Microsoft
DP-900 · Question #145
Which clause should you use in a select statement to combine rows in one table with rows in another table?
The correct answer is A. JOIN. https://learn.microsoft.com/en-us/sql/relational-databases/performance/joins?view=sql-server-
Submitted by wei.xz· Mar 30, 2026Identify considerations for relational data on Azure
Question
Which clause should you use in a select statement to combine rows in one table with rows in another table?
Options
- AJOIN
- BVALUES
- CSET
- DKEY
How the community answered
(28 responses)- A89% (25)
- C7% (2)
- D4% (1)
Explanation
https://learn.microsoft.com/en-us/sql/relational-databases/performance/joins?view=sql-server-
Topics
#SQL JOIN#T-SQL#table joins#SELECT statement
Community Discussion
No community discussion yet for this question.