Question

vb 操作多张数据表

'连接数据库
strsql="provider=Micfosoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "/Result.mdb;Persist Security Info=False"
If con.State<>asStateClosed Then con.Close
con.Open strsql
'打开数据表
'打开表Calibrations
tmpstr="select * from Calibrations"
If rsAccess.State<>adStateClosed Then rsAccess.Close
rsAccess.Open tmpstr,con,adOpenDynamic,adLockPessimistic
'打开表Meters
......
'打开表Tests
......
'按要求将上述3张表的部分内容整合到一张表
tmpstr="select Calibrations.CalibrationId,Meters.Position,Tests.LabTemperature from (Calibrations LEFT JOIN Meters ON (Calibrations.CalibrationId=Meters.CalibrationId) AND (Calibrations.EquipmentId=Meters.EquipmentId)) LEFT JOIN Tests ON (Meters.CalibrationId=Tests.CalibrationId) AND (Meters.EquipmentId=Tests.EquipmentId) AND (Meters.Position=Tests.Position)"
If rsAccess.State<>adStateClosed Then rsAccess.Close
rsAccess.Open tmpstr,con,adOpenDynamic,adLockPessimistic

运行时提示，对象'Open'的方法'_Recordset'失败
感觉以上操作数据库的方法一次只能操作一张表，不能同时操作多张表。
也许表述不太清楚，但我想看过代码的各位应该都能明白我的意思。
请各位大神不吝赐教。

Answer 1

select * from t1,t2,t3 where t1.a=t2.a and t2.a=t3.a

追问

刚试验了下,的确可以运行通过.请问为什么上面的句子不行呢?感觉你这个句子就是我上面的句子的精简版.
还望不吝赐教.

Answer 2

:'连接数据库
strsql="provider=Micfosoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "/Result.mdb;Persist Security Info=False"
If con.State<>asStateClosed Then con.Close
con.Open strsql
'打开数据表
'打开表Calibrations
tmpstr="select * from Calibrations"
If rsAccess.State<>adStateClosed Then rsAccess.Close
rsAccess.Open tmpstr,con,adOpenDynamic,adLockPessimistic
'打开表Meters
......
'打开表Tests
......
'按要求将上述3张表的部分内容整合到一张表
tmpstr="select Calibrations.CalibrationId,Meters.Position,Tests.LabTemperature from (Calibrations LEFT JOIN Meters ON (Calibrations.CalibrationId=Meters.CalibrationId) AND (Calibrations.EquipmentId=Meters.EquipmentId)) LEFT JOIN Tests ON (Meters.CalibrationId=Tests.CalibrationId) AND (Meters.EquipmentId=Tests.EquipmentId) AND (Meters.Position=Tests.Position)"
If rsAccess.State<>adStateClosed Then rsAccess.Close
rsAccess.Open tmpstr,con,adOpenDynamic,adLockPessimistic

运行时提示，对象'Open'的方法'_Recordset'失败
感觉以上操作数据库的方法一次只能操作一张表，不能同时操作多张表。
也许表述不太清楚，但我想看过代码的各位应该都能明白我的意思。
请各位大神不吝赐教。我来帮他解答