> From what you are saying it appears VFPs SQL is
>not very efficent at handling data groups
>internally! This makes sense since with 2 SQLs
>you are running 2 seperate commands (2 SQLs) and
>creating 2 seperate cursors. That is twice the
>work. If it takes 1 SQL (total) statement longer
>then 2 then I would say there is a data grouping
>(segmenting?) problem. If 'we' are aware of this
>then we can write better SQLs (faster) if we keep
>this in mind.

i noticed that with some SQL statements with fp2.x as well
hopefully i am wrong - and it something i am not doing right
:)

Arnon