I have 2 tables within SFMC both with
SubscriberKey as the only field, which is the primary Key.
SubscriberKeys that exist in both tables.
Test1 has 1,700,000 records and Test 2 has 400,000 records, of which exist in Test1. I am trying to use
EXCEPT to pull out all 400k from Test1 and push into a new DE, Test3.
I seem to remember using
EXCEPT, which has worked for me before, but cannot seem to get it to work this time.
The query I am using is:
select * from [Test 1] EXCEPT select * from [Test 2]
I've tried to keep it as simple as possible, however running the above query gives me the exact amount of records as in the table Test1 (1,700,000), where i would expect (1,300,000).