This works fine:

SELECT a.users_status FROM webmail_users a,webmail_dgraph b,webmail_tempid c
WHERE a.userid=b.dgraph_userid
And b.dgraph_tempid=c.temp_id
And a.users_status='Not Validated'

I would want it to be more generic to have

b.dgraph_tempid in (Select c.temp_id from webmail_tempid c)

Is it that Mysql 3.2X will not support this type of Subquery? Not an expert on Mysql.

Anup


=_= =_= =_= =_= =_= =_=


You can chain me, you can torture me, you can even destroy this body, but you will never imprison my mind.
-Mahatma Gandhi

MySQL 3.X does not support sub-queries.
========================================
Buh Bye!

Cheers,
Me