In operator without ()
When coding an SQL statement that includes the "IN" operator you must surround the list of items to test with parenthesis. For example, to see if a value is one of a set of values you could code in the WHERE clause of an SQL query:
WHERE Publishers.State IN ('TX', 'CA', 'WA')
This code tests to see if the State Field is either Texas, California, or Washington.