34,576
社区成员
发帖
与我相关
我的任务
分享
--drop table t1,t2
create table t1( Fld_Type_Oid varchar(10), Fld_Type varchar(10))
insert into t1
select 'A', '添加' union all
select 'B', '删除' union all
select 'C', '修改'
create table t2(Fld_Type_Oid varchar(10), Fld_Op_Oid varchar(20))
insert into t2
select 'A', '20140324001' union all
select 'B', '20140324001' union all
select 'A', '20140324002'
go
select a2.Fld_Op_Oid,t2.Fld_Type_Oid
from
(
select Fld_Type_Oid from t1
)a1
cross join
(
select distinct Fld_Op_Oid from t2
)a2
left join t2
on t2.Fld_Op_Oid = a2.Fld_Op_Oid and
t2.Fld_Type_Oid = a1.Fld_Type_Oid
left join t1
on t1.Fld_Type_Oid = t2.Fld_Type_Oid
/*
Fld_Op_Oid Fld_Type_Oid
20140324001 A
20140324001 B
20140324001 NULL
20140324002 A
20140324002 NULL
20140324002 NULL
*/