If no table is open, Visual FoxPro displays the Open dialog box so you can specify the file location. Once open, the table remains open once the query is complete.
>
So it is like saying that the table has to be opened before it will be able to run then query. That VFP doesn't automatic use the Open dialog for joins is interesting. But I would say it is always a good idea to open the tables first, so you do not confuse the users of your program (or even yourself 6 months from now).
>
>HTH,
Actually, VFP will bring up Open dialog only if it cannot find the table in Default folder (or on Path). If there are some tables, they will be open automatically, and it may cause exactly the situation that is considered in this thread, i.e. some table (with the same alias, but different structure) was already open.