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
>>
>>
--sb--