如何更改此查询，以便仅当它在选择b中并且在选择中时才选择该数字c？
with a(v) as
(
select 1 from dual
union all
select 2 from dual
union all
select 3 from dual
),
b(v) as
(
select 1 from dual
union all
select 9 from dual
union all
select 5 from dual
),
c(v) as
(
select 1 from dual
union all
select 2 from dual
union all
select 5 from dual
)
select * from a
where
not exists (select 1 from b where a.v = b.v) and
not exists(select 1 from c where a.v = c.v);
小提琴