select distinct (pc.id,pc.PolicyPremiumID),pc.policyPremiumCatID,b.nin,b.firstname+‘'+coalesce((b.middleInitial),'')+’+b.lastname as fullname,b.gender,ppc.amount from bio_data b,medicalInsurance m,policy p,policyPremium pp,premiumCategories pc,policyPremiumCategory ppc where b.nin=m.pati