Question

vb中如何同时读取ACCESS数据库中的多个表的记录

Answer 1

set rs=server.CreateObject("adodb.recordset")
rs.open "select * from **",conn,1,1

set rs1=server.CreateObject("adodb.recordset")
rs1.open "select * from **",conn,1,1
定义多个变量就可以了

Answer 2

添加多个ado控件，一个控件连一个表，反正控件又不要钱

Answer 3

rec.open "select [a].name,[b].age,[c].height from a,b,c where a.no = b.no and b.no = c.no and a.no =1"
从abc3表中分别取出1条记录3个字段，每条记录的no字段都是1

Answer 4

select A,b from t1 union select a,c from t2
用上面的sql语句