I am trying to join 4 data views in single query and storing the result in data extension.
Select o.AccountID, o.JobID, o.ListID, o.SubscriberID, o.BatchID, o.SubscriberKey, o.EventDate, s.EmailAddress, s.Status, s.DateUnsubscribed FROM _Open o INNER JOIN _subscribers s ON o.SubscriberKey= s.SubscriberKey INNER JOIN _Click c ON o.SubscriberKey = c.SubscriberKey INNER JOIN _Unsubscribe u ON u.SubscriberKey = c.SubscriberKey
I am not sure can i do in that way. Because when running query is sucessful and no error in actionlog but no data is displaying.
I have tried with 3 data views it worked.