Fleur-GM of Marketing Cloud Campaigners
10/14/2019 - 11:22 AM

Is active in All subscribers - MC DE Emailaddress is Subscriberkey

SELECT
d.EmailAddress,
d.firstname,
d.lastname,
d.gender,
l.status as status
FROM [DE NAME] d
INNER JOIN _ListSubscribers l ON l.SubscriberKey = d.EmailAddress
WHERE l.ListId = '12345' and l.status = 'active'