is it posssible to execute a delete query statement that joins the same table, i've tried various joins (inner, left) but no luck mysql returns error
example of what i need:
DELETE `a` FROM `t1` AS `a`
INNER JOIN `t1` AS `b` USING `some_field_b`
WHERE
`a`.`some_field_a` = 'value_x' AND
`b`.`some_field_a` = 'value_y'