求助各位高手，语法问题

我有两个查询 ，如何能根据c_name把相同项合并到同一行上？
SELECT e.c_name AS KD ,count(DISTINCT a.c_reg_id ) AS RS FROM k_fy_m a,k_fy_d b,b_item c,p_deptemp e
WHERE a.c_type IN('1','I','J')
AND a.c_op_date>'2016.01.01 00:00:00'
AND a.c_op_date<'2016.01.31 23:59:59'
AND ((convert(char(8),a.c_op_date,108) >='17:30:00'
and convert(char(8),a.c_op_date,108) <'23:59:59' )
OR (convert(char(8),a.c_op_date,108) >='00:00:00'
and convert(char(8),a.c_op_date,108) <'07:59:59' ))
AND a.c_id =b.c_bill_id
AND b.c_item_id =c.c_id
AND c.c_ddd<>0
AND a.c_kddept_id =e.c_id
GROUP BY e.c_name
SELECT f.c_name AS KSKD,count(DISTINCT d.c_code ) AS KSRS FROM u_reg_out d,p_deptemp f
WHERE d.c_op_date>'2016.01.01 00:00:00'
AND d.c_op_date<'2016.01.31 23:59:59'
AND ((convert(char(8),d.c_op_date,108) >='17:30:00'
and convert(char(8),d.c_op_date,108) <'23:59:59' )
OR (convert(char(8),d.c_op_date,108) >='00:00:00'
and convert(char(8),d.c_op_date,108) <'07:59:59' ))
AND d.c_dept_id =f.c_id
GROUP BY f.c_name