怎么这么乱?看着太累,我给你重写吧。
dim rs1 as new adodb.recordset
dim rs2 as new adodb.recordset
dim i as integer
dim maxid as integermaxid=-1
rs2.open "select max(aid) from table1",conn,3,2
if rs2.recordcount>0 then maxid=rs2.fields(0).value
rs2.closefor i=1 to 10
rs1.open "select aid from table1 where aname='" & c(i) & "'",conn,3,2
if rs1.recordcount=0 then
conn.execute "insert into table1 (aname) values ('" & c(i) & "')"
maxid=maxid+1
end if
conn.execute "insert into table2 (bid,aid) values ('" & i+1 & "','" & maxid & "')"
next
dim rs1 as new adodb.recordset
dim rs2 as new adodb.recordset
dim i as integer
dim maxid as integermaxid=-1
rs2.open "select max(aid) from table1",conn,3,2
if rs2.recordcount>0 then maxid=rs2.fields(0).value
rs2.closefor i=1 to 10
rs1.open "select aid from table1 where aname='" & c(i) & "'",conn,3,2
if rs1.recordcount=0 then
conn.execute "insert into table1 (aname) values ('" & c(i) & "')"
maxid=maxid+1
end if
conn.execute "insert into table2 (bid,aid) values ('" & i+1 & "','" & maxid & "')"
next
对了,里奥你说的join能不能给出一个例子~~~~谢谢~~