Exam4Training

Which SQL statement should the consultant use?

A consultant needs to send an email to subscribers who have made a purchase.

The data used for the send exists on two data extensions–Subscribers and OrderTable, and the customer would like to include key information from both tables, such as:

* CustomerlD

* FirstName

* EmailAddress

* OrderlD

* OrderDate

* ShippedDate

Which SQL statement should the consultant use?
A . SELECT T1.CustomerID, T1.FirstName, T1. EmailAddress, T2.OrderlD, T2.0rderDate, T2.ShippedDate FROM ‘ Subscribers OUTER JOIN OrderTable ON Subscribers.CustomerlD=OrderTable.CustomerlD
B . SELECT * FROM Subscribers WHERE CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate – JOIN OrderTable On CustomerlD=CustomerlD
C . SELECT CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate FROM Subscribers INNER JOIN OrderTable ON CustomerlD=CustomerlD
D . SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderlD, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN OrderTable T2 ON T1.CustomerID=T2.CustomerID

Answer: D

Exit mobile version