>Borislav:
>
>Sorry, when I set up the thread, they ask you to specify which version, but I can't see how that's visible when you look at the message!??
>
>I'm running VFP9 SP1 with Windows XP. I in the middle of testing Segey's solution and I'm not sure that it works.
>
>Yossi
>
>>Yossi,
>>it is always better to tell us what version of VFP you use, especially when the question is SELECT-SQL related, because with VFP9 you could do more than previous versions of VFP.


It is not possible that Sergey's solutions doesn't work, period. :-)
This query is the same as Sergey's but it uses JOIN instead of EXISTS().
Try:

SELECT inv.*;
       FROM Invoices inv;
INNER JOIN Daterange dr ON inv.Category = dr.Category                           AND;
                           inv.Deliverydate BETWEEN dr.DateBegin AND dr.DateEnd AND;
			   dr.FlockNum      BETWEEN Flbegin AND Flend;

If this didn't works, can you post what result you want from the data you post in your first question.