안녕하세요 아래 쿼리에서 결과값이 나올 수 있는 쿼리 부탁드립니다

with a as (

select 'a' as col1 , 10 as val from dual union all

select 'b' as col1 , 10 as val from dual union all

select 'c' as col1 , 10 as val from dual union all

select 'd' as col1 , 10 as val from dual),

b as (

select 'a' as col1 , 'OK' as chk from dual union all

select 'b' as col1 , 'OK' as chk from dual union all

select '*' as col1 , 'NO' as chk from dua)

select a.col1,a.val,b.chk

  from a,b

 where ~~

<결과값>

a   10    OK

b   10   OK

c   10   NO

d   10  NO