><snip>
>
>>BTW there is no need to open tables BEFORE select, just issue this select, but make sure that you have a path to tables you refer in it.
>
>I have to disagree with you. It's a good programming practice to explicitly open all requred tables and it's only way to avoid "Open File" dialog in case when table cannot be found for some reason in VFP versions pror to VFP9.

Yes, that way you'll get the Open table dialog before select. I just wanted to mention that there is no need to open them before SELECT. Also there is no need to open one table several times becuase you use it in SELECT with different aliases.