-it's good training to do things on SQL Servers where it might simpler to have one query. Also it is less XBase. :)

-shurely one can split it into commands (SELECT DISTINCT to temp; SELECT FROM temp with additional fields; remove temp). I do that for tests remove it wait for VFP to crash by to complex operations and put it back :)

-SELECT DISINCT is faster without the additionals
-at least it as more elegant to add the memo and the rest of the additionals after SELECT DISTINCT with a second SELECT then endless ALTER TABLE (if it works with cursors at all, I'm not shure about this)


>I'm sure that you can do it in one command, but in practice it's two separate operations for your computer. I believe your solution will be faster.
>