创建数据库 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
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'
最后想显示CASE_ID=‘bbbb’的数据为 ID NAME 1 '东风' 2 '南风' 3 '西风' 4 '北风'
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
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'
ID NAME
1 '东风'
2 '南风'
3 '西风'
4 '北风'