SELECT * FROM Properties RIGHT JOIN todelete ON (Properties.propertyid = todelete.id);
DELETE Properties FROM Properties INNER JOIN todelete ON (Properties.propertyid = todelete.id);
subselect sql查询不适用于mysql 4
SELECT * FROM Properties RIGHT JOIN todelete ON (Properties.propertyid = todelete.id);
DELETE Properties FROM Properties INNER JOIN todelete ON (Properties.propertyid = todelete.id);