I have a query in Marketing Cloud which searches for records in my
I have a condition where it excludes records if the values are within a certain range, what I've noticed is it will exclude those records but also exclude any records with
NULL values even though it's not been explicitly added to the
Here is what my query looks like
SELECT c.ID, c.Email, c.FirstName as FirstName, c.LastName as LastName
from Contact_Salesforce c
JOIN Account_Salesforce a ON a.Id = c.AccountId
WHERE ((a.Type <> 'Intern'
AND a.Type <> 'Contractor'
AND a.Type <> 'School Intern'
AND a.Type <> 'Internal User')
OR a.Type IS NULL)
You can see the only way I've found around this is by creating a rule set and explicitly looking for records where
Type IS NULL.
Can anyone explain why the query doesn't include null values if I don't add
a.Type IS NULL?