create table schema.table_name as (
select b.parent_ID
from
schema.table_01 a,
schema.table_02 b,
schema.prod1_child_ID c,
schema.prod2_child_ID d

where a.ky_num=b.ky_num
and a.ID=c.ID or a.ID=d.ID
) with data;