Question

请教一个sql的问题。想把select结果插入insert语句应该怎么做？（代码如下…想把mytcno插进去。多谢！

select c.teachCourseNo as mytcno from Course a,TeachCourse b,SelectCourse c where a.courseNo=b.courseNo and b.teachCourseNo=c.teachCourseNo and a.courseName='高等数学' and c.studentNo='103401'

insert into SelectCourse(studentNo,teachCourseNo,grade) values ('103401',mytcno,99)

Answer 1

insert into SelectCourse(studentNo, teachCourseNo, grade) 
select c.studentNo, c.teachCourseNo as mytcno, 99
from Course a
join TeachCourse b on a.courseNo=b.courseNo 
join SelectCourse c 念歼汪on b.teachCourseNo=c.teachCourseNo 
where 1=1
and a.courseName='高仔仔等数学'改野 
and c.studentNo='103401'

Answer 2

insert 碧模差into 码则表悔皮名(studentNo,teachCourseNo,grade) select c.teachCourseNo as mytcno from Course a,TeachCourse b,SelectCourse

Answer 3

insert into SelectCourse(studentNo,teachCourseNo,grade) 
select 念歼汪'103401',c.teachCourseNo as mytcno,99 from Course a,TeachCourse b,SelectCourse c where a.courseNo=b.courseNo and b.teachCourseNo=c.teachCourseNo and a.courseName='高仔仔等数改野学' and c.studentNo='103401'