SELECT
	pa2.No_Proposal,
	pa2.No_Polis,
	prs.Nama_Perusahaan,
	pa2.Tgl_Mulai,
	pa2.Tgl_Selesai,
	pp2.Id_Produk,
	pp2.Nama_Paket,
	sk.Nama_Sub
FROM
	(
    SELECT
	    pa.No_Proposal
    FROM
	    dbo.Polis_Asuransi AS pa INNER JOIN
	    dbo.Produk_Polis AS pp ON pa.No_Proposal = pp.No_Proposal
    WHERE
      pa.Status = 'I'
      AND pp.Status = 'I'
    GROUP BY
      pa.No_Proposal
    HAVING
      COUNT(pa.No_Proposal) = 1
  ) AS a INNER JOIN
  dbo.Polis_Asuransi AS pa2 ON a.No_Proposal = pa2.No_Proposal INNER JOIN
  dbo.Perusahaan AS prs ON pa2.No_Prs = prs.No_Prs INNER JOIN
  dbo.Produk_Polis AS pp2 ON a.No_Proposal = pp2.No_Proposal INNER JOIN
  dbo.Sub_Kelompok AS sk ON pp2.Sub_Kelompok = sk.Sub_Kelompok
ORDER BY
  prs.Nama_Perusahaan