First of all, that error is coming from the database engine, the LDC is simply delivering it. Your field name has a space in it. You cannot query most databases without enclosing field names that have spaces in square brackets - that is part of the ANSI standard query language.
Go in to your database query browser and plug in the query. The you can change the query until it works, then go back to the workflow and fix it.
The first thing I would do is put the field Vender Item No_ in brackets: [Vendor Item No_ ] since the database is actually telling you where the error is.
Senior Director Support Americas