re: Select in select

[Richard Morton]

Hi,

With any version before 4.1.x you are not able to do sub-selects as you have described
below.

4.1.0 is still in very early alpha testing.

To overcome this problem you can use programming logic, or, use a temporary table.

HTH

Regards,

Richard



 >>  Hy

 >>  I have Mysql 3.23 can i do a select in a select ?
 >>  something like

 >>  SELECT * FROM TABLE1 WHERE ( SELECT MAX(FIELD) FROM TABLE2 ) =
 >>  TABLE1.FIELD

 >>  Thanks