SELECT
  isp.Kode_Santunan,
  ism.Nama_Santunan,
  pa.No_Polis,
	pa.No_Proposal,
	prs.Nama_Perusahaan,
	--pa.Status,
	isp.Id_Produk,
	sk.Nama_Sub,
	isp.Klaim--,
	--pp.Status
FROM
	dbo.Item_Santunan_Polis AS isp INNER JOIN
	dbo.Item_Santunan AS ism ON isp.Kode_Santunan = ism.Kode_Item INNER JOIN
	dbo.Produk_Polis AS pp ON isp.Id_Produk = pp.Id_Produk INNER JOIN
	dbo.Polis_Asuransi AS pa ON pp.No_Proposal = pa.No_Proposal INNER JOIN
	dbo.Perusahaan AS prs ON pa.No_Prs = prs.No_Prs INNER JOIN
	dbo.Sub_Kelompok AS sk ON pp.Sub_Kelompok = sk.Sub_Kelompok
WHERE
  isp.Kode_Santunan = 'RG04'
  AND pp.Status = 'I'
  AND pa.Status = 'I'
ORDER BY
  prs.Nama_Perusahaan,
  pa.No_Proposal,
  pp.Id_Produk