> SELECT NVL( apd.nstkjour, T.nstock ) AS nStkjourCor, apd.iTraiterId ; > FROM AgendaPhar apd ; > JOIN Traiter T ON T.iid = apd.itraiterId ; > WHERE apd.ddate < vp_date ; > ) >>
>>UPDATE ap >> SET nstkjour = pd.nstkjour >> FROM AgendaPhar ap >> JOIN ( >> SELECT NVL(apd.nstkjour, t.nstkjour) AS nstkjour, apd.nID >> FROM AgendaPhar apd >> JOIN Traiter t ON t.iid = apd.itraiterId >> WHERE apd.ddate < vp_date >> ) pd ON ap.nID = pd.nID >>>>
>>> vp_date = DATE() >>>* I want the stock From yesterday >>>*-- If not exist in agendaPhar i get the stock from Traiter.dbf >>> >>>UPDATE AgendaPhar ; >>> SET ; >>> NVL( nstkjour = ( SELECT apcor.nstkjour FROM AgendaPhar apcor ; >>> INNER JOIN Traiter Tcor ON Tcor.iid = apcor.itraiterId WHERE apcor.ddate < vp_date ) , 0 ) >>> >>>>>>