>>>>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...
---------------
Hi Nadya - thanks... I will add that to my notes...:)