DELETE FROM EMP
WHERE
    EMP_CODE IN (
        SELECT EMP.EMP_CODE
        FROM EMP
        JOIN EMP_INVALID AS INV
        ON EMP.EMP_CODE = INV.EMP_CODE
        WHERE
            EMP.VALID_FLG <> '1'
    );