ssql="select st.student_name,sc.student_id,co.course_name," & _
"sc.course_id,sc.score from scores sc"
ssql=ssql & "inner join course co on co.course_id=sc.course_id"
ssql=ssql & "inner join students st on sc.student_id=st.student_id"
ssql=ssql & "where st.student_num='"& studentnum &"'"
ssql=ssql & "and sc.course_id="& cint(courseid)
有没有高手可以帮我改啊，急用，就要交了，谢了！！！

ssql="select st.student_name,sc.student_id,co.course_name,sc.course_id,sc.score from scores sc"
ssql=ssql & "inner join course co on co.course_id=sc.course_id"
ssql=ssql & "inner join students st on sc.student_id=st.student_id"
ssql=ssql & "where st.student_num='"& studentnum &"'"
ssql=ssql & "and sc.course_id="& cint(courseid)

有没有提示错误信息啊

你把错误提示发上来看看