Thank naomi.

I begin to understand.
Where = INNER JOIN ...

Euh....What is traiter in english ? ( Google give me nothing )...:)

bernhart

>Bernhart,
>
>I try to answer your question one last time.
>
>If you need stock from Traiter <g>, just use it on the left side and do a left join with your other table. Move where condition on date to JOIN clause e.g.
>
> select ... From Traiter left join Agenda on .. and Agenda.dDate < ?vp_date
>
>You can also use UNION as I showed in my other sample, AFAIK the result should be identical.
>
>>>Perhaps VFP doesn't like "traiters"? <g>
>>
>>
>>LOL
>>
>>bernhart
>>