SELECT
	mpg.NamaPegawai, mk.NamaKategori, 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 AND date( mp.TanggalJual ) >= '2010-05-19' AND
					date( mp.TanggalJual ) <= '2010-05-19' AND mp.CabangJual = 'Tiga Putra Dinoyo'
WHERE
	mk.LevelKategori = 0
GROUP BY
	sb.JenisBarang, mpg.KodePegawai