I didn't know that multiple inScope is SQL standard:
select pk.PK_FIRST_ID, pk.PK_SECOND_ID
from WHITE_COMPOUND_PK pk
where (pk.PK_FIRST_ID, pk.PK_SECOND_ID) in (
select ref.REF_FIRST_ID, ref.REF_SECOND_ID
from WHITE_COMPOUND_PK_REF ref
where ref.REF_FIRST_ID = pk.PK_FIRST_ID
and ref.REF_SECOND_ID = pk.PK_SECOND_ID
)
I didn't know that multiple inScope is SQL standard:
so it should be supported.
[my memo]