--创建表
create table changeclass
(
oldcid int,
newcid int
)
--插入数据
insert into changeclass
select 1,4
union
select 2,3
union
select 3,2
union
select 4,1
--创建班级表
create table class
(
cid int,
cname nvarchar(50)
)
--插入数据
insert into class
select 1,'A-Class'
union
select 2,'B-Class'
union
select 3,'C-Class'
union
select 4,'D-Class'
--获得结果
select b.cname as 原班名,
c.cname as 新班名
from changeclass a
left outer join
class b
on a.oldcid = b.cid
left outer join
class c
on a.newcid=c.cid
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024