Problem with subquery

[Marc Clifton]

Hi All,

I have a very simple query with a subquery:

select ID from STATION where ID NOT IN (SELECT STATION_ID FROM ADDTL_COSTS)

and I get the error:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT STATION_ID FROM ADDTL_COSTS)' at line 1

What am I missing? Both select statements run fine individually.

Thanks!

Marc