Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement