RE: [PHP-DB] Newbie Question: Convert SELECT to DELETE statement in mysql

Are you trying to delete records with a SELECT statement? That can't be done. To delete from two different tables, you must use two different DELETE statements. -----Original Message----- From: Shaun Honsvick [mailto:shonsvick@ce-group.com] Sent: Tuesday, October 16, 2001 3:59 PM To: php-db@lists.php.net Subject: [PHP-DB] Newbie Question: Convert SELECT to DELETE statement in mysql I am trying to run a delete on a mysql database. The delete query needs to delete from 2 tables. The select statement is: SELECT tinvoices.*, ttrackingnumbers.* FROM tinvoices LEFT JOIN ttrackingnumbers ON tinvoices.InvoiceID = ttrackingnumbers.InvoiceID WHERE Date < '2001-08-01'; I can't seem to get a delete statement to work. (This is my first project) Thanks, Shaun -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net