вот как надо было
DELETE FROM guest,answers USING guest INNER JOIN answers WHERE guest.id_msg = answers.msg_id AND answers.msg_id =2;