[quote=PacoPepe;394347]
Código SQL
[-]
select d.dia, rm.suma from dias d left join (select extract(day from fecha) as dia, sum(kgs) as suma from Recepcion where ano = 2010 group by dia ) as rm on d.iddia = rm.dia
esta consulta la hice de esta manera y si me sale como tu quieres
Código SQL
[-]
select d.dia, rm.suma from dias d left join (select dia, sum(kilos) as suma from consumo where anio = '2011' group by dia ) as rm on d.dia = rm.dia