how to union two tables with group values :       **How to union two tables with group values**      
      -----------------------------------------
      My Query:
      SELECT  
      table1.holder,table1.bene_type,table1.bene_stype,employee.employee_name,
      count(employee.employee_name) as count,sum(table1.position) 
      as totalshares FROM erom_kmch.table1 LEFT OUTER JOIN erom.employee ON 
      employee.bene_type_table1=table1.bene_type 
      AND employee.bene_stype_table1=table1.bene_stype WHERE table1.date =
      '2016-04-15' group by employee.employee_name UNION 
      SELECT 
      table2.cust_name, table2.type,table2.bo_substat,employee.employee_name,
      count(employee.employee_name) as count,sum(table2.shares) as totalshares
      FROM erom_kmch.table2 LEFT OUTER JOIN erom.employee 
      ON  employee.type_table2=table2.type 
      AND  employee.bo_substat_table2=table2.bo_substat WHERE table2.date =
     '2016-04-15' group by employee.employee_name
      ----------------------------------------------------------
I am joining and union two tables and i need to group the values of two tables ,i am getting two output i need the sum and count of two tables as one output
