NTO puts the word TEST at the beginning of the name for each test emai. Which query would return the subs who were sent those emails?

Question

Jebaz Norton · Accepted Answer

SELECT * FROM _Job J INNER JOIN _Sent S ON.JobID = S.JobID WHERE J.EmailName LIKE 'TEST%'

Jebaz Norton · Answer

SELECT * FROM _Job J INNER JOIN _Sent S on J.EmailName LIKE 'TEST%'

Jebaz Norton · Answer

SELECT * FROM _Job INNER JOIN _Sent on JobID = JobID WHERE EmailName LIKE 'TEST%'

Jebaz Norton · Answer

SELECT * FROM _Job J INNER JOIN _Sent S on J.JobID = JobID = S.JobID WHERE J.EmailName = 'TEST%'

List of questions