That's a great recomendation, this thread comes as a way to know how to improve the FROM clause and correlated sentences with the new VFP9 UPDATE-SQL feature.

Thanks again.

>One way or the other the time is spent mostly in summing. Maybe you could consider a trigger on cmovs updates for your frequently needed sums and keep them in a support table ready to be used.