[PHP-DB] delte stmt problem with joins
by Merlin other posts by this author
Aug 29 2003 1:33PM messages near this date
Re: [PHP-DB] MySQL: CREATE TABLE, BLOB, UNIQUE, INDEX etc
|
Re: [PHP-DB] delte stmt problem with joins
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thread:
Merlin
John W. Holmes
Merlin
John W. Holmes
|
