SQL error

[ATElearner]

I have this SQL, which works well. select model_no  from bclabel where barcode = '%s'

After I changed it to

 select inv_item_id from Wmds Chassis Serialno where chassis_serial = '%s'

I got this error message: Conn Execute.vi->Pollchassis.vi<ERR>Exception occured in Microsoft OLE DB Provider for Oracle,  ORA-00933: SQL command not properly ended
.  in Conn Execute.vi->Pollchassis.vi

All I did is just changing the table and column? Please help. Thanks a lot.

[Dennis_Knutson]

I think the problem is the table name. I don't use table names with spaces in them but you can try putting the table name inside square brackets like [Wmds Chassis Serialno]. If I create a query in access, the SQL View shows the table name that way.

[ATElearner]

Thanks. I do not think that is the issue. I tryied your suggestion adn this time I got "invalid table name" error.