Is it possible to query for open data from an email in a Journey. I've been having trouble extracting that into a data extension. I'm using this query
SELECT c.JobID,c.SubscriberKey FROM _Open c INNER JOIN ( SELECT JobID,EmailName FROM _Job ) j ON j.JobID = c.JobID WHERE j.EmailName = 'Journey Email 1'
My results data extension has EmailName, JobID, and SubscriberKey. There are no errors that result from this however I'm not getting any data either.