delte stmt problem with joins

[Merlin <news.groups@web.de>]

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