1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| insert into TABLE (CibleId, TempsId,Campaignid,CustomerId,Clics, OClics)
select T.CibleId, T.TempsId, T.Campaignid, T.CustomerId, T.Clics, T2.OClics
from CiblesClics T INNER join CiblesClicsOpens T2 on
(T.CibleId= T2.CibleId and
T.TempsId = T2.TempsId and
T.Campaignid = T2.Campaignid and
T.CustomerId = T2.CustomerId)
UNION
Select T3.CibleId, T3.TempsId, T3.Campaignid, T3.CustomerId, T3.Clics
from CiblesClics T3 where
T3.CibleId NOT IN (select CibleID from CiblesClicsOpens) OR
T3.TempsId NOT IN (select TempsID from CiblesClicsOpens) OR
T3.CampaignId NOT IN (select CampaignID from CiblesClicsOpens) OR
T3.CustomerId NOT IN (select CustomerID from CiblesClicsOpens)
UNION
Select T4.CibleId, T4.TempsId, T4.Campaignid, T4.CustomerId, T4.OClics
from CiblesClicsOpens T4 where
T4.CibleId NOT IN (select CibleID from CiblesClics) OR
T4.TempsId NOT IN (select TempsID from CiblesClics) OR
T4.CampaignId NOT IN (select CampaignID from CiblesClics) OR
T4.CustomerId NOT IN (select CustomerID from CiblesClics); |
Partager