Alex,

Read the rest of the posts in this thread for all the details. You basically can't depend on how VFP will open tables during the select, it may USE AGAIN the table so the alias argument won't point to the right place.

>Whatever you mean sounds interesting and important. Please explain more fully what you mean.
>
>I have done multitable SELECTs where of course I could not use one of the RECNO() to order things, yet obtained results ordered as I wanted them, (in the original order of one of the tables) without fully knowing why.