I'm trying to write a SQL query in a marketing cloud automation studio activity

  [table 1]
  [field 1] IN (

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

  • 1
    Since you only have 1 "item" in your "IN" list, you may have to remove that extra comma. (You only have one comma in the whole query, so it should be pretty easy to determine which one I'm referencing!)
    – Helpful
    Mar 8, 2018 at 0:52
  • Hey thanks for responding. I actually edited the original query, which had alot more values. I've edited the original post with a new query with additional values and its still showing a ')' error during syntax validation
    – Mark Koh
    Mar 8, 2018 at 0:59

1 Answer 1


Remove the last , before the bracket. It's the last item and doesnt need to be followed by a ,

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .