Hi! I´m new to SQL language and I´d like to know how to select all data from several tables. If I´ve got only one table the SQL sentence would be like: strSQL="SELECT * FROM EMPLOYESS " but, what if I need to access all data from 10 different tables at the same time?
You need to join the tables. The simplest solution is to create your query using the query design grid then go to SQL view on the View toolbar. You can then copy and paste the SQL. If the fields are the same, you need to use a Union query.