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