MySQL 4.1 .vs. MySQL 4.0.13 (fwd)

I wonder if my user can follow section 1.7.4.1 in mysql.com for what he wants to do without me upgrading the MySQL from 4.0.x to 4.1 alpha This is what my user wants [snip] I believe I will need sub-selects for the following type of query. Subqueries are not supported until MySQL 4.1. I will n

MySQL 4.1 .vs. MySQL 4.0.13 (fwd)

I was wondering if anyone can give a direction on this sub-query issue. Do I must upgrade it to MySQL 4.1 alpha or is there an alternative on MySQL 4.0.13 as a workaround to sub-query Thanks -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08 There's no place like 127.

MySQL 4.1 .vs. MySQL 4.0.13 (fwd)

Hi I have a user who needs to do the following [snip] I believe I will need sub-selects for the following type of query. Subqueries are not supported until MySQL 4.1. I will need to do longest-match lookups in the DB to mimic the way that IP routers do longest-match routing lookups. In the m