create table E(ID int,CODE int,NAME varchar(10))
insert E select 1,1,'aaaa'
union all select 2,2,'bbbb'
union all select 3,3,'cccc'
union all select 4,4,'dddd'
go
改为
create table E(ID int,CODE int,NAME varchar(10))
insert E select 1,1,'东风'
union all select 2,2,'南风'
union all select 3,3,'西风'
union all select 4,4,'北风'
union all select 5,5,'红中'
go
最后想显示CASE_ID=‘bbbb’的数据为
ID NAME
1 'aaaa'
2 'bbbb'
3 'cccc'
4 'dddd'
创建数据库
create table A(ID int,CASE_ID varchar(10),CODE int)
insert A select 1,'aaaa' ,1
union all select 2,'bbbb' ,1
union all select 3,'cccc' ,1
go
create table B(ID int,CASE_ID varchar(10),CODE int)
insert B select 1,'aaaa' ,2
union all select 2,'bbbb' ,2
union all select 3,'cccc' ,2
go
create table C(ID int,CASE_ID varchar(10),CODE int)
insert C select 1,'aaaa' ,3
union all select 2,'bbbb' ,3
union all select 3,'cccc' ,3
go
create table D(ID int,CASE_ID varchar(10),CODE int)
insert D select 1,'aaaa' ,4
union all select 2,'bbbb' ,4
union all select 3,'cccc' ,4
go
create table E(ID int,CODE int,NAME varchar(10))
insert E select 1,1,'aaaa'
union all select 2,2,'bbbb'
union all select 3,3,'cccc'
union all select 4,4,'dddd'
go