select couname,couno
from course
union all
select state,couno
from StuCou
order by couno
--问题3.查看课程表，课程名称以及报名状态的情况，并将数据存在coursestate表中，
select couname,couno into coursestate
from Course
union
select state,couno
from StuCou
order by CouNo
drop table coursestate