Having issues with an ExecuteSQL statement.
I have a user created list of keywords. I need to find the keywords in another table which will have a short description and a numeric value. I need to search the description for the keywords and return both the numeric value and the description.
I can't seem to get the WHERE clause with IN working properly.
ExecuteSQL ( "
SELECT nc_class, nc_class_description
WHERE currently_pulling_hair_out IN frustration
What would the proper WHERE statement be?