What MySQL version are you running? Original Message dated 2/25/04, 9:19:43 AM Author: Gregorio <[EMAIL PROTECTED]> Re: Nested queries:
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
