SELECT
	mpg.NamaPegawai, sb.JenisBarang, IFNULL(sum(dp.jumlah),0) AS Jumlah
FROM
	masterpegawai mpg
	CROSS JOIN stokbarang sb
	LEFT JOIN detailpenjualan dp ON dp.KodePegawai = mpg.KodePegawai AND dp.IdBarang = sb.IdBarang
	LEFT JOIN masterpenjualan mp ON mp.NoNotaJual = dp.NoNotaJual
WHERE
	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