I got some issues updating a boolean field in MC. In fact, I have 2 tables, [Journey - Prospects] and [Contacts]. On the Prospects table, I have a boolean field 'Buyer' that is false.
What I want is : If the email adress contained in the Prospect table exist in the Contacts table, then I want to update the field 'Buyer' on the Prospects table as 'true'.
Here is my SQL :
SELECT J.[EMAIL], CASE WHEN (C.[EMAIL] is not null) THEN J.[Buyer] as 'true' FROM [Journey - Prospects] J INNER JOIN [Contacts] C ON C.[EMAIL] = J.[EMAIL]
But somewhere, my syntaxe is not right, can you help me ?
Thanks for your help !