请指出下面代码的错误之处

显示全部楼层 · 2007-6-6 10:08:19

tmpsql="select degree from joinclass where classid="&classid&_ " and isauditing=0 and userid=(select userid from student where studid="&memberid&")"第一行的 _ 要离 & 这个远点

千问 · 2007-6-6 10:08:19

把userid=(select userid from student where studid="&memberid&")"改成userid in (select userid from student where studid="&memberid&")"如果子查询有多条数据用等号就会出错

千问 · 2007-6-6 10:08:19

1楼说的正确，＿要与＆中间有个空格