我的SQL语句怎么啦!
我今天试了SQL语句,还是不行,错误是'pings.pid=project.pid and pings.zid=zhuan.zid and zhuan.zid'这一句,说是查询语句的语法错误。我百思不得其解,谢谢!
原句是
sql="select project.*,pings.*"
sql=sql&" from project,pings,zhuan"
sql=sql&" where pings.pid=project.pid and pings.zid=zhuan.zid and zhuan.zid="&request("zid")
rst.open sql,conn