Can you post the code ?

>
>I have still a problem sergey.
>
>Here is a sample table and a picture
>
>Tempa.dbf
>http://cjoint.com/data/hrsUUf1jES.htm
>
>UT4 picture
>http://cjoint.com/data/hrsQZe7Byw.htm
>
>I want change nstkjour ( For the same itraiterId ) for igendadateid = 12 with the Value
>of nstkjour - nconsjour For iagendadateid < 12.
>
>Here im my picture = 49 - 1 = 48 But my code do'nt function any more.
>
>Please Sergey help me.
>
>Thank
>
>bernhart
>I have
>
>
>>You have to use LEFT JOIN in order to upadte all records in the v_AgendaPhar. With INNER JOIN the records in v_AgendaPhar that don't have matching records in derived table pd will not be updated.
>>

>>  UPDATE v_AgendaPhar  ;
>>      SET nstkjour = NVL( pd.nStkjourCor , 0 ) +1 ;
>>    FROM v_AgendaPhar;
>>      LEFT JOIN(;
>>        SELECT apd.nstkjour AS nStkjourCor , apd.itraiterId ;
>>          FROM  AgendaPhar apd ;
>>          WHERE apd.iagendadateid < vp_id ) pd ;
>>    ON v_AgendaPhar.itraiterId = pd.itraiterId
>>

>>