Help - Join tables syntax

Results 1 to 2 of 2

Thread: Help - Join tables syntax

  1. #1
    Shawn Brown Guest

    Default Help - Join tables syntax

    I need to join two access tables and can&#039t figure out the correct syntax. Here is what I have:<BR><BR>sql = "SELECT * FROM Employee INNER JOIN Departments ON Employee.DeptID = Department.DepartmentID"<BR>

  2. #2
    Sathiya Guest

    Default RE: Help - Join tables syntax

    try this syntax it gives EQUI Join<BR><BR>sql = "SELECT * FROM Employee, Departments where Employee.DeptID = Department.DepartmentID"<BR><BR>and i think u didnt use "where" in your syntax<BR><BR><BR> <BR><BR><BR> <BR><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