求一SQL语句：子表通过一个非主键属性排除主键所在的所有行,多谢！

一个问题：子表通过一个非主键属性排除主键所在的所有行？
比如:

create table tmp_main
(pk_field integer);
insert into tmp_main(pk_field) values(1);
insert into tmp_main(pk_field) values(2);
commit;

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
)

t_detail表里有flag_field = '1'的行，我想把满足这个条件的主键值的所有过滤掉

select b.* FROM tmp_main a,t_detail b where a.pk_field = b.pk_field and ...

想要显示的结果是：
pk_field flag_field
2 0
2 0

请热心朋友帮忙，非常感谢！