有表表一查询出表二的样式
(表一)
(表二)
select t.stname name,'数学' subject , t.math grade from s t
union
select t.stname name,'英语' subject , t.english grade from s t
有表表一查询出表二的样式
(表一)
(表二)
select t.stname name,'数学' subject , t.math grade from s t
union
select t.stname name,'英语' subject , t.english grade from s t