在关键字 'select' 附近有语法错误。

[germ007]

<%
set rs1=server.CreateObject("adodb.recordset")
    rs1.open "select city from user_table1 where age>20 group by sex",conn,1,1'////选择出年龄大于20的人员，并且以性别分组
   do while not rs1.eof
   conn.Execute("drop table #temp,select username,school into #temp from user_table2 where city='"&rs1("city")&"'")'////些句显示在关键字 'select' 附近有语法错误。

......

%>

user_table1
username city age sex
tom hb 23 m
john ci 33 m
jack hb 15 m
tony hb 55 f


user_table2
username city school
tom hb a
john ci b

[germ007]

ding

[gelinqing]

分号？

[germ007]

ding:)

[germ007]

谢谢，已通过