冒险岛2钓鱼粉色章鱼:ASP 数据库查询语句怎样写？

来源：百度文库编辑：高校问答时间：2024/04/29 04:16:21

SQL="select * from student,choose_course where (choose_course.teachername='"+Session("teachername")+"')and ("&choose_course.studentid&"="&student.studentid&") and (choose_course.c_num="&CInt(cc_num)),

错误类型：
Microsoft VBScript 编译器错误 (0x800A0401)
语句未结束
/dbwork/teacher/end_mark.asp, line 26, column 198
SQL="select * from student,choose_course where (choose_course.teachername='"+Session("teachername")+"')and ("&choose_course.studentid&"="&student.studentid&") and (choose_course.c_num="&CInt(cc_num)),
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------^

请问要怎样修改这个句子达到我想要的三个条件查询？谢谢

SQL="select * from student,choose_course where choose_course.teachername='" &Session("teachername") &"' and choose_course.studentid=student.studentid and choose_course.c_num='"&CInt(cc_num)&"'"

"SELECT *
FROM student INNER JOIN
choose_course ON
choose_course.teachername='"+Session("teachername")+"'
and choose_course.studentid=student.studentid
and choose_course.c_num="&CInt(cc_num)

照你的意思应该是这样

ASP 数据库查询语句怎样写？ SQLSERVER2000数据库的查询语句怎么写 asp中的查询语句怎么写数据库查询语句问题！ SQL数据库查询语句关于数据库查询语句 sql语言模糊查询语句怎样写？ asp 语句查询 asp中的查询语句 asp中的这个查询语句不会写，求助！