Hi I'm trying to write an SQL query in ET, that will look for subscribers in our master data file, and then build out a data extension to use in some other automations for suppression.
Here is the query that I have written:
SELECT b.*
FROM [Master Data DE] as b
WHERE b.syCampusid = '5 or 8'
It doesn't look as though it's finding any data with that query, I'm trying to find all the records where the syCampusid
is 5
or 8
.
Thanks!