I need to exclude List to whom the particular email has been sent previously from Automation Studio via SQL Activity (Data views).
select distinct s.SubscriberKey
from _sent s
join _job j
on j.jobid = s.jobid
where (j.EmailName = '@Email Name here')
Using Update operation in SQL Activity. It is giving values to my target data extension at first time.
But at next time its not working when i click on Run once.
Any Help would be much appreciated.