CREATE TABLE table1 AS
  SELECT DISTINCT f.clm_cntl_num,
                  d.car_dme_line_key,
                  f.claim_key,
                  f.bene_clm_acnt_num,
                  f.bene_ident_cd,
                  d.line_dgns_cd,
                  d.line_1st_expns_dt,
                  d.line_last_expns_dt,
                  d.line_hcpcs_cd,
                  f.org_npi_num,
                  d.carr_line_prfrmg_npi_num,
                  d.dmerc_line_suplr_npi_num,
                  d.line_prvdr_tax_num,
                  d.line_plc_srvc_cd,
                  d.line_prvdr_pmt_amt,
                  e.bene_hicn_num
  FROM   table2 m
         join carclm.clm_fact f
           ON m.bene_clm_acnt_num = f.bene_clm_acnt_num
         join carclm.car_dme_line_grp d
           ON d.claim_key = f.claim_key
         join dcs1.car_clm_fact_ext e
           ON d.claim_key = e.claim_key
         left join hcpcs_exclu3 x
           ON x.hcpcs = d.line_hcpcs_cd
  WHERE  m.bene_ident_cd = f.bene_ident_cd
         AND e.net_flag = 'Y'
         AND d.line_1st_expns_dt >= m.clm_from_dt
         AND d.line_last_expns_dt <= m.clm_thru_dt
         AND x.fy = To_char(m.clm_from_dt + 92, 'YYYY')