Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003

    Unanswered: how to select several tables

    Hi! Im new to SQL language and Id like to know how to select all data from several tables. If Ive 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?

    Thanks a lot in advanced.

  2. #2
    Join Date
    Aug 2002
    Northampton, England
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts