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'
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php