mySQL subqueries

[topr8]

quote from manual:
Up to version 4.0, only nested queries of the form INSERT ... SELECT ... and REPLACE ... SELECT ... are supported. The IN() construct can be used in other contexts.

i assume this means that i cannot to this:

select col from table1 where col IN ( select d from table2)

but i can do this:

select col from table1 where col IN (1,2,3)

eg i can list the values but not use a select statement

[coopster]

That is correct. Unless your MySQL version is >= 4.0 :)