Im trying to update a Data Extension with data from another Data Extension, very simple, you'd think.
The target Data Extension has SubscriberKey as Primary Key and the source Data Extension doesn't have a Primary Key, but I wanted to avoid issues with this by using DISTINCT in the Query. My Query looks like this
SELECT DISTINCT SubscriberKey, EmailAddress, Language, Country FROM DataExtension01
I keep get the error Violation of PRIMARY KEY constraint. Cannot insert duplicate key. Shouldn't DISTINCT solve this?
Hoping you can help.