我想从Course,Class,Teacher表中查询数据Student_id,course_id,course_year,Teacher_id然后插入Student_course表中,怎么实现?下面是我在程序中用到的Sql字符串,有错误,请大家帮忙指点哈.
string st_sqlstr = "insert into Student_course(Student_id,Course_year,Course_id,Teacher_id) (select Student_id,@Cours_id,@Cours_year @Teach_id from Student,Teacher where Student_class_id=@Clas_id) ";

把你的表结构详细的列出来看一下

上面就是我要操作的表,请指点.

这是我在asp.net中用到的sql语句:
string st_sqlstr = "insert into Student_course(Student_id,Course_year,Course_id,Teacher_id)
(select DISTINCT Student.Student_id,@Cours_year,@Cours_id, @Teach_id from Student,Course,Teacher where Student_class_id=@Clas_id and Teacher_id=@Teach_id) ";
现在搞定了