SELECT DISTINCT l.*, c.* FROM ClientClaims l
INNER JOIN Client c ON c.IdClient = l.IdClient
INNER JOIN ClientPolicy p ON p.IdClient = c.IdClient
WHERE p.OccupationId IN (73,74,86,87,109,31, 122)