DELETE FROM EMP
WHERE EMP.EMP_CODE IN (SELECT EMP.EMP_CODE FROM EMP JOIN EMP_INVALID ON EMP.EMP_CODE = EMP_INVALID.EMP_CODE WHERE NOT (EMP.USER_UPDATE_DATETIME > EMP_INVALID.USER_UPDATE_DATETIME AND EMP.VALID_FLG = '1'))