JDBC Lookup error

[pankaj_yadav3]

Hi Expert

I am using the JDBC lookup in my scenario , In my table 3 columns -BusinessUnitEntityKey,SKUIdentifier,RnSKUEntityKey, I want to pick the data based on BusinessUnitEntityKey,

Like:SELECT "SKUIdentifier", "RnSKUEntityKey" FROM "SAP_RNA_SKUS" WHERE BusinessUnitEntityKey= "9011"," 101"

once i run my lookup is is showing error : Cause Exception: 'Error processing request in sax parser: Error when executing statement for table/stored proc. 'table' (structure 'statement'): com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '='.'.

it is not picking multiple recoreds at a time .

please help me for this issue .

Regards

pankaj Singh

[Harish]

Hi Pankaj,

AFAIK - you do not need double quote ("") in table and column name in select query. change your query as

SELECT SKUIdentifier, RnSKUEntityKey FROM SAP_RNA_SKUS WHERE BusinessUnitEntityKey= "9011"," 101"

and refer the below link

http://www.w3schools.com/sql/sql_select.asp

regards,

Harish