Is there another answer, asside from in the application and/or as atrigger using `DELETE FROM B WHERE z = 'x';` as it's body?
~Wayne