select couname,couno
from Course
union all
select state,couno
from StuCou
order by couno
select couname,couno into coursestate
from Course
union
select state,couno
from StuCou
order by couno
select*from coursestate
drop table coursestate
--查询学生表的学生姓名，班级表的班级名称，将结果合并到coursestate中
select stuname,classno into classstudent
from Student
union
select classname,classno
from Class
order by classno
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/4650/viewspace-2801242/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
源码解析ThinkPHP.php
请登录后发表评论
登录
全部评论
