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

Hi Robert,

Just curious, why do you always smile? :) Do you enjoy work with VFP or just happy to find answers on your questions?

I'd like to have this attitude...

Cheers :)