General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
>>
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only