WARD_NO PRO_NO EVA_LEVEL
10206 30 A
10206 30 B
10207 31 A
10207 31 B
10207 31 c
表2
PRO_NO EVA_LEVEL
30 A
30 B
30 C
31 A
31 B
31 C
31 D
需要得到的表为：
WARD_NO PRO_NO EVA_LEVEL
10206 30 A
10206 30 B
10206 30 C
10207 31 A
10207 31 B
10207 31 C
10207 31 D
------解决方案--------------------
完整的：
create table 表1(WARD_NO int,PRO_NO int,EVA_LEVEL varchar(10))
insert into 表1
select 10206 , 30, 'A' union all
select 10206 , 30, 'B' union all
select 10207 , 31, 'A' union all
select 10207, 31, 'B' union all
select 10207, 31, 'c'
create table 表2(PRO_NO Int, EVA_LEVEL varchar(20))
insert into 表2
select 30, 'A' union all
select 30, 'B' union all
select 30, 'C' union all
select 31, 'A' union all
select 31, 'B' union all