I have 1st DataExtension names "Accessories" and 2nd as "TestAccessories". I want to dump all the unique records from Accessories to TestAccessories, My query is as follows:
SELECT DISTINCT [Customer Code], Email, Location, [Operator Code], Date, Time, [Customer Group1], GUID FROM Accessories
In Accessories DE GUID is Primary key, and I want unique values from [customer code] field, the above given query is not giving me unique values.What is the other way?
I have tried the same query for finding Distinct emails but it's not giving required output.