multi delete

[Jared]

Hi,

I have MySQL 5.0.22 and I can't seem to do multiple delete 100% on InnoDB
table with Foriegn Key.

What should the correct syntax be?

[Jared]

Found what I want - was USING + RIGHT OUTER
DELETE FROM `sale-equip`,`sale-rooms` USING `sale-equip`
RIGHT OUTER JOIN `sale-rooms` ON `sale-rooms`.id = `sale-equip`.idsale
WHERE `sale-rooms`.id = 64;