Câu 72: Salesforce Certified Marketing Cloud Consultant

A consultant wants to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions named Subscribers andOrders, and the customer needs to include key information from both tables, such as: ✑ CustomerID ✑ FirstName, ✑ EmailAddress ✑ OrderID ✑ OrderDate ✑ ShippedDateWhich SQL statement should the consultant use?

1. A. SELECT * FROM Subscribers WHERE CustomerID, FirstName, EmailAddress, OrderID, OrderDate, ShippedDate JOIN Orders On CustomerID=CustomerID
2. B. SELECT CustomerID, FirstName, EmailAddress, OrderID, OrderDate, ShippedDate FROM Subscribers INNER JOIN Orders ON CustomerID=CustomerID
3. C. SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderID, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN Orders T2 ON T1.CustomerID=T2.CustomerID — đáp án hiện tại
4. D. SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderID, T2.OrderDate, T2.ShippedDate FROM Subscribers OUTER JOIN Orders ON Subscribers.CustomerID=Orders.CustomerID