DELETE FROM TAB_A JOIN TAB_B ON ID.TAB_A = ID.TAB_B
DELETE FROM TAB_A FROM TAB_A JOIN TAB_B ON TAB_A.ID = TAB_B.ID