David,
>
>>Check the example in the "Differences between xBase and SQL implementations" thread with the references i gave within another thread.
>
>Just for completeness of thread, see my improved benchmark test code I posted Thread #305631 Message #306539 a few minutes ago. The proper SQL beats the Xbase code and IMHO the select is more readable and maintainable because it's one line of code instead of 9 lines that may be spread over a much greater distance of lines.

My proposal is to hide these complexity and use them trough a VFP view, so these line will be replaced by a single USE 'MyVFPView'

Please, check my reply to your message Thread #305631 Message #306539

Walter,