I am trying to update a boolean field of my Data Extension based on the value of some other field. can I use SQL UPDATE statement to do so? Though when I tried writing this query, it gave me an error
"Incorrect syntax near the keyword 'UPDATE'."
If UPDATE cannot work, is there any other approach by which we can do this?
Something like:
UPDATE [Table1] a
SET a.Field1 = 'True'
WHERE a.Field2 IN ('1','2','3','4')
When conducting a JOIN function, you need to specify what the 2 tables are joining on.
Try this:
SELECT
[Account ID] AS 'Account ID'
,[Created Date Backend] AS 'Created Date'
FROM [DE A] A
INNER JOIN [DE B] B ON A.[Account ID] = B.[Lead ID]
Note that you may need to specify what table Account ID and Created Date Backend come from.
Reference: https://www.w3schools.com/sql/sql_join.asp
This image will help you understand the basics of JOINs:
There's no aggregation/grouping going on in your query there to do the "> 0" evaluation.
Try this:
SELECT
csf.Id as SubscriberKey,
csf.channel__c as Channel,
COUNT(1) as HasHardBounced
FROM
Contact_Salesforce csf INNER JOIN
_Bounce b WITH (NOLOCK)
ON b.SubscriberKey = csf.Id
WHERE
b.BounceCategory = 'Hard bounce'
GROUP BY
csf.Id
HAVING
COUNT(1) > 0
Best Answer
No, only SELECT statements are allowed.
You can, however, specify
Update,OverwriteorAppendas the action on the target Data Extension.Reference