MySQL nested selects

[blackhead]

Hi

Please help me with MySQL!

I need to query something like this:

SELECT * FROM a WHERE NOT id IN ( SELECT a FROM c WHERE b = {x} )

While:

A
--------------------
id int (pk)
name char

B
----------------------
id int (pk)
name char

C
--------------------
id int (pk)
a int ref a
b int ref b


and {x} means perviously selected value from B table.

I know I'm not able to query MySQL that way. It doesn't support subselects using IN keyword. But how to solve this query?

Please help me.

Thank you for your further reply!

Bye George