select brg.kodebrg,brg.namabrg, gg_hpn010.total, gg_hpn037.total from 
((select br.kodebrg,br.namabrg 
		from (barang br inner join jualdetail ff on br.kodebrg=ff.kodebrg) inner JOIN
			jual jj on jj.nofaktur=ff.nofaktur 
	where ( br.groupe='010') 
	and ( jj.kodesales='HPN010' or  jj.kodesales='HPN037')
	and jj.tanggal>='2015-02-01' and jj.tanggal<='2015-02-07' 
 group by br.kodebrg,br.namabrg ) brg 
	left join 
	(
	select aa.kodebrg ,dd.namabrg, sum(aa.jumlah) as total
	from ((jualdetail aa left join jual bb 
			on aa.nofaktur=bb.nofaktur ) left join  sales cc
			on cc.kode=bb.kodesales) left join barang dd
			on dd.kodebrg=aa.kodebrg
		
	where bb.tanggal>='2015-02-01' and bb.tanggal<='2015-02-07' 
		and bb.kodesales='HPN010'
	group by cc.nama, aa.kodebrg, dd.namabrg
	order by aa.kodebrg,dd.namabrg
	) gg_hpn010 on brg.kodebrg = gg_hpn010.kodebrg 
) left join 
	(
		select aa.kodebrg ,dd.namabrg, sum(aa.jumlah) as total
		from ((jualdetail aa left join jual bb 
				on aa.nofaktur=bb.nofaktur ) left join  sales cc
				on cc.kode=bb.kodesales) left join barang dd
				on dd.kodebrg=aa.kodebrg
			
		where bb.tanggal>='2015-02-01' and bb.tanggal<='2015-02-07' 
			and bb.kodesales='HPN037'
		group by cc.nama, aa.kodebrg, dd.namabrg
		order by aa.kodebrg,dd.namabrg
	) gg_hpn037 on brg.kodebrg = gg_hpn037.kodebrg 


order by brg.kodebrg