> 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 ; > ) >>
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 ; union ; select T.nStock AS nStkjourCor, apd.iTraiterId ; FROM AgendaPhar apd ; JOIN Traiter T ON T.iid = apd.itraiterIdThis would add records where dates are >=vp_date