title: combining 2 queries into 1 so output is on single row
body: <p>I'm trying to combine the output of both the below queries so they output on one row any help you can provide will be very much appreciated.</p>
  
  <p>Query 1:</p>
  
  <pre><code>select FLT_NUM, SCH_DEP_DATE, sum (GROSS_WGT) as UWS_GROSS_WGT,  sum (NETT_WGT) + SUM(BULK_WGT) as UWS_NETT_WGT
  from
  (select distinct  
          d.aln_code||d.flt_num as FLT_NUM, 
          trunc (d.sch_dep_date) flight_date,
          d.brd_pnt, 
          d.off_pnt,
          trunc(d.sch_dep_date) as Departure_date,
          to_date(to_char(d.sch_dep_date, 'DD-MON-YYYY')||''||d.sch_dep_time_hrs||':'||d.sch_dep_time_min, 'DD-MON-YYYY HH24:MI') as SCH_DEP_DATE,
          a.gross_wt as GROSS_WGT, 
          a.tare_wt as TARE_WGT, 
          a.nett_wt as NETT_WGT, 
          a.shpmnt_wt as BULK_WGT
  
  
  from  cfr_leg d, cfr_uws_hdr e, CFR_LEG_SEG f,CFR_UWS_LOAD_DTLS a
  where d.fll_id = e.fll_id (+)
    and d.fll_id = f.fll_id
    and d.fll_id = a.fll_id
    and d.flt_num = '0001'
    and trunc (d.sch_dep_date) between  '29-OCT-2016' and '29-OCT-2016'
    and d.brd_pnt = 'LHR'
    and f.opn_mode = 'J')
  
  group by FLT_NUM, SCH_DEP_DATE
  </code></pre>
  
  <p>Query 2:</p>
  
  <pre><code>select 
  
  FLT_NUM,SCH_DEP_DATE, sum (BKD_WGT), sum (BKD_VOL)
  
  from
  (Select  distinct
           a.aln_code||a.flt_num as FLT_NUM, 
           trunc(a.dep_date)as SCH_DEP_DATE, 
           b.doc_prfx, 
           b.doc_num, 
           a.bkd_wt as BKD_WGT, 
           a.bkd_vol as BKD_VOL     
  from sbh_res_itnry a, sbh_car b, sbh_res c
  where c.car_id = b.car_id (+)
    and c.car_id = a.car_id 
    and a.aln_code = 'VS'
    and a.flt_num = '0001'
    and trunc (a.dep_date) = '29-OCT-2016'
    AND a.cncl_ind = 'N'
    and b.cncl_ind = 'N'
    and c.enq_ind = 'N')
  
  group by FLT_NUM,SCH_DEP_DATE
  </code></pre>
  
  <p>I have tried using union all but it outputs the data over 2 rows</p>
  
  <pre><code>VS0001  29-Oct-2016             21365.09    92.404281
  VS0001  29-Oct-2016             22595       21907
  </code></pre>
  
  <p>I would like to see output as follows:</p>
  
  <pre><code>FLT_NUM SCH_DEP_DATE   UWS_GROSS_WGT  UWS_NETT_WGT   BKD WGT  BKD_VOL
  VS0001  29-Oct-2016    21365.09        92.404281       22595   21907
  </code></pre>