I've got little to add about multiple queries being faster. I'm just curious about the particular example you posted. In the older dialects of VPF in which I work, the query

SELECT CNT(*) as nTotal FROM ATable INTO CURSOR crsCursor2 GROUP BY Field1

gives the same result as your 2nd example (unless I've missed even more than I usually do).

Do later versions of VFP not support GROUP BY queries that don't include the aggregating fields in the query itself?




>Hi,
>
>Is there a speed advantage to using separate SELECT commands as opposed to humping them up into a single command using sub queries?
>
>Here's an example of what I'm refering to:
>

>SELECT Field1,CNT(*) as nTotal FROM ATable INTO CURSOR crsCursor1 GROUP BY Field1
>
>SELECT nTotal FROM crsCursor1 INTO CURSOR crsCursor2
>

>
>as opposed to
>
>

>SELECT nTotal FROM (SELECT Field1,CNT(*) as nTotal FROM ATable GROUP BY Field1) INTO CURSOR crsCursor2
>

>
>The first example is more of a pain to clean up after but is easier to debug. I'm just wondering if there is a runtime speed advantage to any of them.
>
>Aloha,
>
>James