delte stmt problem with joins
| From: | Merlin | Date: | Fri, 29 Aug 2003 13:33:24 +0000 |
| Subject: | delte stmt problem with joins | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-30225@lists.php.net to get a copy of this message | ||
Hi there,
I would like to delete a row inside a mysql table. To find out which rows are affected the system has to check another table.
Somehow I am doing this statement wrong and I cant find out why. Does anybody see the error?
Thanx for any help on that.
DELETE
FROM $table1 pi
RIGHT JOIN $table2 AS p ON p.ID = pi.product_id
WHERE p.owner_id = '15173'
Merlin