DELETE FROM EMP WHERE EMP_CODE IN (SELECT EMP.EMP_CODE FROM EMP INNER JOIN EMP_INVALID ON (EMP.EMP_CODE == EMP_INVALID.EMP_CODE AND EMP.VALID_FLG == 0));