17,140
社区成员




with t_detail as(
select 1 as pk_field,'0' as flag_field from dual
union all
select 1 as pk_field,'0' as flag_field from dual
union all
select 1 as pk_field,'1' as flag_field from dual
union all
select 1 as pk_field,'0' as flag_field from dual
union all
select 2 as pk_field,'0' as flag_field from dual
union all
select 2 as pk_field,'0' as flag_field from dual
)
select b.* FROM t_detail b where not exists (select 1 from t_detail t,tmp_main t2 where b.pk_field=t.pk_field and t2.pk_field=t.flag_field)
with t_detail as(
select 1 as pk_field,'0' as flag_field from dual
union all
select 1 as pk_field,'0' as flag_field from dual
union all
select 1 as pk_field,'1' as flag_field from dual
union all
select 1 as pk_field,'0' as flag_field from dual
union all
select 2 as pk_field,'0' as flag_field from dual
union all
select 2 as pk_field,'0' as flag_field from dual
)
select b.* FROM t_detail b where not exists (select 1 from tmp_main t where b.pk_field=t.pk_field)
with t_detail as(
select 1 as pk_field,'0' as flag_field from dual
union all
select 1 as pk_field,'0' as flag_field from dual
union all
select 1 as pk_field,'1' as flag_field from dual
union all
select 1 as pk_field,'0' as flag_field from dual
union all
select 2 as pk_field,'0' as flag_field from dual
union all
select 2 as pk_field,'0' as flag_field from dual
)
select b.* FROM t_detail b where not exists (select 1 from tmp_main t where b.flag_field=t.pk_field)