I'm trying to write a SQL query in a marketing cloud automation studio activity
SELECT
*
FROM
[table 1]
WHERE
[field 1] IN (
'a2F6F000002WUVmUAO',
'a2F6F000002WTqbUAG',
'a2F6F000002WT8DUAW',
'a2F6F000002WT9QUAW',
'a2F6F000002WSghUAG',
'a2F6F000002WTAKUA4',
)
However I keep getting a Incorrect syntax near ')'. error.
Does anyone know how to fix this error? I can't seem to find anything wrong with the syntax of my sql
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
Remove the last
,before the bracket. It's the last item and doesnt need to be followed by a,