DP-900 Exam - Question 291

Question

You have an Azure SQL database that contains tables for customers and orders.

You need to create a query that will return the orders placed by each customer.

Which two Transact-SOL statements should you include in the query? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Examice · Accepted Answer

OnlineCH · Answer

SELECT * FROM Orders o JOIN Customers c ON o.CustomerId=c.Id

Roy34 · Answer

Select for listing and join for joining

SIH007 · Answer

If you want to see the customers' orders you should use ORDERBY, using SELECT would not meet the requirement to return the orders by customer.

Discussion