I am writing a bunch of queries to update All Subscribers list, and was surprised to see that when I put the condition
xxx != yyy it only works if there are values in both columns.
I was hoping that it would also return records if column
xxx was empty. So now, I also included the following condition:
OR xxx IS NULL.
Is this the correct way to handle this?
SELECT ... WHERE allsubs.Column1 != salesforcedata.Column1 OR allsubs.Column1 IS NULL