Error to IN Operator with sub query

[sksk]

I have a problem to use IN Operator in MySQL. IN operator do not work with sub query. My syntax was

Select Id From Item Where Item.Id NOT IN (Select ItemId From salespricequot)

Display the error:

Error Code : 1064
You have an error in your SQL syntax near 'Select ItemId From salespricequot)

please give me solution

[r035198x]

Are you sure what you posted above is exactly the query you issued?

[Atli]

sksk.

Please use [code] tags when posting your code examples. (See How to ask a question)

[code=sql] ...SQL query goes here... [/code]

Thank you.
Moderator

[Atli]

What version of MySQL are you using?
Using subqueries with the IN function may not work on versions prior to version 5 (although the manual seems to include it for them...)

[debasisdas]

there is no reason why the query will throw error. Please check your table name and field name correctly.

[mwasif]

Using subqueries with the IN function may not work on versions prior to version 5 (although the manual seems to include it for them...)

These are supported prior to MySQL 5.