28,391
社区成员
发帖
与我相关
我的任务
分享
connstr="Driver={microsoft access driver(*.mdb)};dbq=*.mdb;"
sqlstr="select a.userid as userid,a.pinID as pinID,b.name as names,b.kuai as kuai,b.gui as gui,b.beizhu as beizhu from pro_info b,user_xuan a where a.userid='0001' and a.pinID=b.pinID and a.dangid='000000001'"
rs.open sqlstr,conn,1,1
select A.a1,A.a2,B.b1,B.b2,C.c1,C.c2 ...... from Atable A,Btable B,Ctable C where A.id = B.id(相关连的字段) and A.id = C.id(相关连的字段)