SELECT DISTINCT c.IdClient, c.ClientName, c.FirstName, c.LastName, p.* FROM ClientPolicy p
INNER JOIN Client c ON c.IdClient = p.IdClient
INNER JOIN PolicyDataForm q ON q.IdPolicy = p.IdClientPolicy
INNER JOIN PolicyData dAgencyName ON dAgencyName.IdPolicyForm = q.Id AND dAgencyName.IdVariable = 74998
WHERE p.IdInsurance = 1972 AND dAgencyName.[VALUE] = 'Insurica Agency'