Accessing 2 tables

Results 1 to 2 of 2

Thread: Accessing 2 tables

  1. #1
    Join Date
    Dec 1969

    Default Accessing 2 tables

    How do you display a record set from 2 different table in the same DSN? I am using access as my db. I know how to do it with one table. <BR><BR>Please Help<BR><BR>Thank You<BR>Aaron

  2. #2
    R Gibson Guest

    Default RE: Accessing 2 tables

    Here is an example of selecting employee number and name from Table1 and a set of skills (skill1, skill2) from table2 where empNum (a field located in both tables) is equal.<BR><BR>"SELECT Table1.empNum,, Table2.skill1, Table2.skill2<BR>FROM Table1 INNER JOIN Table2 ON Table1.empNum = Table2.empNum"<BR><BR>Hope this helps.<BR><BR>Thanks,<BR><BR>-rg<BR><BR>Thanks,<BR><BR>

Posting Permissions

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