delete multiple lines from multiple tables using inner join code example
Example: delete join select from one table based on multiple values
DELETE A.* FROM table1 A INNER JOIN table2 b
ON A.id = B.id
AND a.field1 = b.field1
AND a.field2 = b.field2
AND a.field3 = b.field3
AND b.id = ?;