MySQL does not currently support sub-selects. The manual says: DELETE [LOW_PRIORITY | QUICK] FROM table_name [WHERE where_definition] [ORDER BY ...] [LIMIT rows]
Did you review the manual first? -----Original Message----- From: Riccardi Moreno [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 9:48 AM To: Php List; Mysql List Subject: [PHP-DB] Delete problem Hi all, I'm trying to delete records with this query on php program: delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where ID_GROUP = '$group') I use it on MSSQL and work fine but on mysql don't work, there's some other query that make the same result on mysql Thank's all -------------------------------------------- - Moreno Riccardi - www.webtrade.it -------------------------------------------- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php