>>>In vfp60, I have a database called mydatabase. I would like to open mydatabase with …OPEN MYDATABASE… and I would like to set up all the tables in this database so I can just call on them with a SELECT – SQL statement.
>>>Any ideas?
>>
>>As long as the database is open and the active one, a SQL select will automatically open the tables for you if they are not open.
>------------
>Hi Larry - ok, you are saying, if your database is opened then all tables
>in that database can be access with select....thanks...:))

You may do it explicitly, if you want:
select * from myDatabase!myTable1 inner join myDatabase!myTable2...