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?

Sign in or unlock DP-900 to reveal the answer and full explanation for question #145. The question stem and answer options stay visible for context.

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

Unlock DP-900 to see the answer

You've previewed enough free DP-900 questions. Unlock DP-900 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#SQL JOIN#T-SQL#table joins#SELECT statement
Full DP-900 Practice