To retrieve subscribers who were sent emails with names starting with "TEST," we need to join the _Job and _Sent system data views on the JobID field and filter by the EmailName field using a LIKE condition.
Join Condition: The correct join condition between _Job and _Sent is ON J.JobID = S.JobID. This ensures that we are linking the job and sent data correctly.
EmailName Filter: We use J.EmailName LIKE 'TEST%' to filter for emails whose names start with "TEST".
SELECT * FROM _Job J INNER JOIN _Sent S ON J.JobID = S.JobID WHERE J.EmailName LIKE 'TEST%'
[: Salesforce Marketing Cloud System Data Views, , ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit