insert into lab_stu_course select Cou_num,Cou_name,Cou_flag,Cou_period from lab_course where Cou_ID=123
如果还要往表lab_stu_course中加一项user_ID(在表lab_stu_course中为not null)但这一项不在表lab_course中
要怎么写啊?

insert into lab_stu_course (num,name,flag,period,user_ID)
select Cou_num,Cou_name,Cou_flag,Cou_period,b.UserID from lab_course a
join table1 b on ....
where Cou_ID=123

谢谢