sql - How to access three tables from database

Question

I only know how to access data from 2 different tables but not with 3. How do i do it? Thanks in advance

rs.Open("select tblEmp.empID, tblEmp.gn, tblSalary.salary from tblEmp inner join tblSalary on tblEmp.EmpID = tblSalary.EmpID" & "tblPosition.posTitle, tblPosition.posID = tblSalary.posID", con, 3, 3)
    Do Until rs.EOF
        With Me.lv
            .Items.Add(rs.Fields("empID").Value)
            .Items(i).SubItems.Add(rs("gn").Value)
            .Items(i).SubItems.Add(rs("posTitle").Value)
            .Items(i).SubItems.Add(rs("salary").Value)

        End With
    Loop

Answer 1

Something like

SELECT t1.FIELDx, t2.FIELDy, t3.FIELDz
  FROM TABLE1 t1
  INNER JOIN TABLE2 t2
    ON t2.KEY1 = t1.KEY1
  INNER JOIN TABLE3 t3
    ON t3.KEY2 = t2.KEY2

should do it for you.