如何从数据库中访问三个表

Question

我只知道如何访问来自2个不同表的数据，而不知道如何访问3个表的数据。我该怎么做？提前感谢

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

类似的东西

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

应该为你做这件事。