I need to combine results from three different Data Extensions that contains the same set of columns. For each SubscriberKey I'd like to see the Clicks_[Country] and Rating_[Country] even if they have null value.
For most of the records it works fine but for some records SubscriberKey and personal data are missing. Could you please help me solve it?
SELECT ukr.SubscriberKey as SubscriberKey, ukr.FirstName, ukr.LastName, ukr.Email, ukr.Clicks as Clicks_Ukraine, ukr.Rating as Rating_Ukraine, syr.Clicks as Clicks_Syria, syr.Rating as Rating_Syria, afg.Clicks as Afghanistan_Clicks, afg.Rating as Afghanistan_Rating FROM Total_Clicks_Ukraine_V2 ukr FULL OUTER JOIN Total_Clicks_Syria_V2 syr ON ukr.SubscriberKey = syr.SubscriberKey FULL OUTER JOIN Total_Clicks_Afghanistan_V2 afg ON ukr.SubscriberKey = afg.SubscriberKey