To add a table or view to a query
1.- In the Query Designer toolbar, choose Add Table.
2.- In the Add Table or View dialog box, select the database you want to use, choose Tables or Views, select the table or view you want to add, and choose OK.
-or-
If you want to add a table that is not part of the database, choose Other, locate the table in the Open dialog box, and choose OK.
In the Join Condition dialog box, verify the suggested join and choose OK.
If Visual FoxPro cannot suggest a likely match between fields, select the matching fields in the Join Condition dialog box yourself.