Câu 12: Salesforce Certified Marketing Cloud Developer

A developer needs to find all subscribers on the Customers data extension who made a purchase in the last 30 days. Purchase data is on the Orders data extension which contains a column called 'PurchaseDate'. Contacts are identified in both data extensions by a column called 'ContactKey', and the Orders data extension can contain many instances of the same subscriber. Which SQL keyword should the developer use to achieve the desired result?

1. A. OUTER JOIN
2. B. INNER JOIN
3. C. ORDER BY PurchaseDate ASC — đáp án hiện tại