Weird ODBC error when accessing MySQL table via ESS

[cmdrsalamander]

Dear all,

I have an ESS/ODBC error that I cannot fix. When I try access a MySQL table via ESS, I get the following error:

ODBC Error: {MySQL][ODBC 3.51 Driver][mysqld-5.0.92-community-log]You have an erro in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'customers_id IN (24,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,' at line 1

I think I did the ESS config right because other tables display with no issues.

Any help would be greatly appreciated. (Translation: HELP!)

Regards,

Salman