DELETE
FROM EMP AS E
WHERE E.VALID_FLG != "1" AND E.EMP_CODE = (SELECT EMP_CODE FROM EMP_INVALID AS EI WHERE E.EMP_CODE = EI.EMP_CODE);