Hi Hernan

>No, the reason is that with vfp6 there was no other way that writing your SQL sentences because the limitations of the View Designer, mainly because the way it ordered the inner/etc join's and on's. If you try to build the same select in the vfp6's View Designer and the vfp9's View Designer you'll see what I mean.

Okay, thanks I will give it a try.