选择求和条件联接表mysql

我想将“ tbpembelian”中的“ sisastock”列与“ tbproduk”相加。但是我的结果只有一行。

我的查询：

select 
    pe.idprd,  p.nmprd, sum(pe.sisastock) as 'totalsisastock', 
    pe.tglmasuk, k.idkat, d.iddvs 
from 
    tbproduk as p 
left join 
    tbpembelian as pe on pe.idprd = p.idprd 
join 
    tbkategori as k on p.idkat = k.idkat 
join 
    tbdivisi as d on p.iddvs = d.iddvs 
having 
    sum(pe.sisastock) > 0 
order by 
    pe.tglmasuk DESC

表“ tbproduk”

表“ tbpembelian”

我想要的结果