nerdexam
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)
  • A
    89% (25)
  • C
    7% (2)
  • D
    4% (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.

Full DP-900 Practice