Nested queries

[Gregorio]

This is the query i want to run but i doesn't work.   select id from c_table where users_id in (select id from users where locations_id=3) order by data_ora   But it gives me this error:   You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select id from users where locations_id=3) order by data_ora   It seems correct to me. What's the problem?     Gregorio _______________________________________________________________________________   IncrediMail - il mondo della posta elettronica si è finalmente evoluto - Clicca Qui