Quries from multiple tables

Results 1 to 2 of 2

Thread: Quries from multiple tables

  1. #1
    Nameeth Guest

    Default Quries from multiple tables

    hi i need some help,<BR> iam using an access database. I have three tables. "A" tables links to "B" and "B" to "c" table. I want to retrive the data from all the tables depending on the information iam looking in table "A". <BR> Is there a site where i could get more information or a smaple of the sql code?...to query multiple tables ..thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Quries from multiple tables

    You should be able to do something like the following...<BR><BR>SELECT a.fieldname, b.fieldname, c.fieldname FROM tablea a, tableb b, tablec c WHERE a.fieldname = &#039Criteria&#039 AND a.fieldequaltob = b.fieldequaltoa AND b.fieldequaltoc = c.fieldequaltob<BR><BR>HTH<BR><BR>Jerry

Posting Permissions

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