John,

In this example, you're trying to emulate the SQL-select within a xBase variant including storing the result

This is just the point, I don't want/need to store the results. I jut want to use the data directly from it's datasource, thus not copying it in another cursor/table

That's why I copied the resultset to an extrernal file for both approaches in the former example.

When VFP will be able group fields from different tables into one alias/workarea (see the wishlist for native VFP views), You'll not need to copy it into a cursor/table.

BTW, if you'll use SQL-INSERT in your example you'll speed up creating the cursor.

Second: Did you test this on a network ? Tip: Reboot your computer between each test because SQL-select tends to chache resultset components so speeding up the query next time you'll execute it.

Walter,