title: How To Combine These 2 Queries into one Query without using union
body: <pre><code>SELECT b.KPCNO
           ,b.KPC_FULL_NAME    
  
  FROM xxkpc_hr_personnel_v2  b
  WHERE  b.type(+) = 'KPC Employee'
         AND b.DESIGNATION is null
         AND b.kpcno IS NOT NULL
         AND b.ORGANIZATION_ID=(select g.ORGANIZATION_ID from  xxkpc_fn_web_personnel_v g where g.kpcno = :kpcno)
  GROUP BY b.KPCNO
            ,b.kpc_full_name
  
  UNION
  
  SELECT b.KPCNO
           ,b.KPC_FULL_NAME
  FROM xxkpc_hr_pos_struct_code_comb   a
       ,xxkpc_hr_personnel_v2  b
  WHERE b.position_id(+) = a.child_position_id
         AND b.type(+) = 'KPC Employee'
         AND b.kpcno IS NOT NULL
         AND a.PERANT_POSITION_ID =  (select g.POSITION_ID from  xxkpc_fn_web_personnel_v g where g.kpcno = :kpcno)
  GROUP BY b.KPCNO
            ,b.kpc_full_name
  </code></pre>
  
  <p>Please I need to combine these 2 queries into one query without using UNION</p>