sql2="......"
sql3 = "select * from (" & sql2 & ")"
rs1.Open sql3, conn, adOpenKeyset, adLockOptimistic这样可以!sql2="......"
sql3 = "select * from (" & sql2 & ") left join per on (" & sql2 & ").并列排名=per.排名"
rs1.Open sql3, conn, adOpenKeyset, adLockOptimistic而这样为什么就不行?为什么啊,百思不得其解!
sql3 = "select * from (" & sql2 & ")"
rs1.Open sql3, conn, adOpenKeyset, adLockOptimistic这样可以!sql2="......"
sql3 = "select * from (" & sql2 & ") left join per on (" & sql2 & ").并列排名=per.排名"
rs1.Open sql3, conn, adOpenKeyset, adLockOptimistic而这样为什么就不行?为什么啊,百思不得其解!
sql3 = "select * from (" & sql2 & ") as a left join per on a.并列排名=per.排名"
rs1.Open sql3, conn, adOpenKeyset, adLockOptimistic