[sql] query annidiate in mysql

[superpelo]

Provo a eseguire questa query annidata in mysql 4.0.12 ma mi esce un messaggio di errore:

mysql> select favorites.wfv_id
-> from favorites, users, workflows, versions
-> where favorites.username=users.username and favorites.wfv_id=versions.wfv_id and workflows.wf_id=version
s.wf_id and users.activity in (select activity from users where username='root');
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server versi
on for the right syntax to use near 'select activity from users where username='root')' at line 3

xke'?

[floyd]

http://dev.mysql.com/doc/mysql/en/subqueries.html
credo siano supportate dalla ver 4.1