I'm trying to update a SendLog data extension with a Query Activity, but I can't.
My DE has these fields:
JobID, ListID, BatchID, SubID, TriggeredSendID, ErrorCode, UniqueID, SentEventDate, OpenEventDate
(The UniqueID, SentEventDate are custom fields)
Now, I want to update the SentEventDate & OpenEventDate field with EventDate of SentEvent & OpenEvent objects, so how should I to write the query in a Query Activity to achieve this intent?
And the criteria is:
DE.BatchID = SentEvent.BatchID AND DE.BatchID = OpenEvent.BatchID AND DE.SubID = SentEvent.SubscriberKey AND DE.SubID = OpenEvent.SubscriberKey