Newbie Question: Convert SELECT to DELETE statement in mysql
| From: | Shaun Honsvick | Date: | Tue, 16 Oct 2001 20:58:43 +0000 |
| Subject: | Newbie Question: Convert SELECT to DELETE statement in mysql | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13397@lists.php.net to get a copy of this message | ||
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