I have the written the query below to return two values. I have also check the DE to ensure that it has the correct data types. Unfornately, the query is not returning any values:
SELECT M.EmailAddress EmailAddress ,M.PersonHasOptedOutOfEmail PersonHasOptedOutOfEmail FROM MasterSubscriberDE M JOIN [4DaySend] F ON M.SubscriberKey = F.SubscriberKey WHERE PersonHasOptedOutOfEmail = 'False'
Here is a screenshot of the Data Extension:
I know its a very basic query but I seem to be missing a trick and stumped by this. Help will be much appreciated.