UPDATE AgendaPhar SET ; nconshebd = ; NVL( TpsMoyHebdo.nSumConsReally / TpsMoyHebdo.nDate , 0 ) ,; dprevision = ; VP_date + ; ICASE( AgendaPhar.nconshebd # 0.00 , FLOOR( AgendaPhar.nstkjour / AgendaPhar.nconshebd ) , 0.00 ) ,; dprevisioncmd = ; ICASE( EMPTY( AgendaPhar.dprevision ) , AgendaPhar.dprevision ,; MAX( AgendaPhar.dprevision - ( TpsMoyHebdo.isemcmd * 7 ) , VP_date ) ); FROM AgendaPhar ; LEFT JOIN TpsMoyHebdo ON TpsMoyHebdo.itraiterId = AgendaPhar.itraiterIdTHank