у меня есть запрос
select
CONCAT(monthname(a.tanggal), ' ', year(a.tanggal)) as bulan_tahun,
sum(a.kg) as kg,
sum(a.ka) as ka,
sum(a.lr) as lr,
sum(a.lh) as lh,
sum(a.lb) as lb,
sum(a.ll) as ll,
sum(a.nc) as nc,
sum(a.na) as na,
sum(a.sbs) as sbs,
sum(a.stbs) as stbs,
sum(a.kg)+sum(a.ka)+sum(a.lr)+sum(a.lh)+sum(a.sbs)+sum(a.lb)+sum(a.ll)+sum(a.nc)+sum(a.na)+sum(a.stbs) as total
from
opr.t_temuan as a
where
a.id_site=197
and a.tanggal between '2010-02-01' and '2011-01-31'
and (a.type ='f' or a.type = 'i')
group by
bulan_tahun
order by
a.tanggal asc
я получаю месяц возврата
June 2010 0 0 5 0 4 6 0 0 3 3 21
July 2010 0 0 99 39 4 4 0 0 2 2 150
August 2010 0 0 62 79 0 5 5 0 0 0 151
September 2010 0 0 1 0 0 0 0 0 0 0 1
November 2010 0 0 59 4 75 1 0 0 8 8 155
December 2010 0 0 1 0 0 0 0 0 0 0 1
но я хочу вернуть месяц с января 2010 года по декабрь 2010 года, как это
January 2010 0 0 0 0 0 0 0 0 0 0
Febuary 2010 0 0 0 0 0 0 0 0 0 0
Marc 2010 0 0 0 0 0 0 0 0 0 0
April 2010 0 0 0 0 0 0 0 0 0 0
May 2010 0 0 0 0 0 0 0 0 0 0
June 2010 0 0 5 0 4 6 0 0 3 3 21
July 2010 0 0 99 39 4 4 0 0 2 2 150
August 2010 0 0 62 79 0 5 5 0 0 0 151
September 2010 0 0 1 0 0 0 0 0 0 0 1
November 2010 0 0 59 4 75 1 0 0 8 8 155
December 2010 0 0 1 0 0 0 0 0 0 0 1
пожалуйста, помогите мне !! Благодарность