I am trying to write a query that gives me all of the subscribers keys from the all subscribers where at least one of these keys has been sent to.
I have written the following syntax:
select DISTINCT(s.SubscriberKey),s.EmailAddress,se.EventDate,se.OYBAccountID from ent._Subscribers s JOIN _Sent se on s.SubscriberID=se.SubscriberID where s.SubscriberKey is not null and se.OYBAccountID='XXXXXX'
However this only gives me the instances of the key when it was sent.
So lets say i have one email address with 2 subscriber key; if i amend the query for those 2 keys it will only show me the one that has been sent to which I kind of get because i do the join with the _Sent data view.
Is there a way to tweak the syntax to achieve what i need?
Thank you, Giulietta