SELECT
sum(can_f) as valor,
cod_pro as pro
FROM
ti
WHERE
cod_ccaja = '2' AND
cod_turno = '4' AND
fec_f = '2013-06-24'
GROUP BY
cod_pro
union all
SELECT
sum(can_ihf) as valor,
cod_pro as pro
FROM
ins
WHERE
cod_ccaja = '2' AND
cod_turno = '4' AND
fec_f = '2013-6-24'
GROUP BY cod_pro
delphi
12; "I0009" 5; "I0005" 9; "I0009" 5; "I0005"
pero quiero que salga asi
delphi
21 I0009 10 I0005
alguien sabe, gracias por su apoyo