You have a Microsoft SQL Azure database that contains a table named Customers. You have a table-valued function named TopCustomers that returns a list of all the customers that have purchased items during the last 12 months. The ID of the customer is passed as an argument to the TopCustomers function. You need to create a query that returns a list of all the Customer names and the purchase dates. The solution must return only customers that have purchased an item during the last 12 months. What should you add to the query?

A. OUTER JOIN
B. CROSS JOIN
C. CROSS APPLY
D. OUTER APPLY

  Discussion forum

Question
0

Leave an answer