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中
要怎么写啊?

谢谢