>Hello Sergey,
>
>I have problem.
>AgendaPhar Have no record with ddate < vp_date
>I want dus T.nstock
>
>

> 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 ;
>    )
>

>
>Give No record and your request give me 0 ..? IN place Of T.nstock
>
>A idea ?
>
You may try:

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.itraiterId

This would add records where dates are >=vp_date