We often use INNER JOIN or OTHER JOIN to select the data from one table and the corresponding data from another table. MYSQL allows you to use INNER JOIN clause with DELETE statement so that you can easily delete records from one table and also the corresponding records from another table.
DELETE zpost ,zcomment FROM zpost INNER JOIN zcomment ON zpost.zpostid = zcomment.zpostid WHERE condition
NOTE : IF you omit zpost table, it would delete records from zcomment. AND if you omit zcomment then it would delete records from zpost.
MySQL DELETE JOIN with LEFT JOIN
You often use LEFT JOIN clause in the SELECT statement to find records that exist in the left table and does not have corresponding records in the right table. You can also use the LEFT JOIN clause in the DELETE statement to delete record in a table (left table) that does not have corresponding record in another table (right table).