<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.