合并查询与删除表

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