SELECT
	mpg.NamaPegawai, sb.JenisBarang, IFNULL(sum(dp.jumlah),0) AS Jumlah
FROM
	masterpegawai mpg
	CROSS JOIN masterkategori mk
	LEFT JOIN stokbarang sb ON mk.NamaKategori = sb.JenisBarang
	LEFT JOIN detailpenjualan dp ON dp.KodePegawai = mpg.KodePegawai AND dp.IdBarang = sb.IdBarang
	LEFT JOIN masterpenjualan mp ON mp.NoNotaJual = dp.NoNotaJual
WHERE
	mk.LevelKategori = 0 AND
	date( mp.TanggalJual ) >= '2010-05-19' AND
	date( mp.TanggalJual ) <= '2010-05-19' AND
	mp.CabangJual = 'Tiga Putra Dinoyo'
GROUP BY
	sb.JenisBarang, mpg.KodePegawai