¿No te funcionó la consulta que te pasé??
Código:
FROM Claims, ClaimsFollowUp, Repricing
WHERE (Claims.ClaimID=ClaimsFollowUp.RepricingID AND Claims.ClaimID=Repricing.RepricingID)
or (Claims.ClaimID=ClaimsFollowUp.RepricingID AND Claims.ClaimID not in (Select RepricingID From Repricing)) or
(ClaimID not in (Select RepricingID From claimsFollowUp) and ClaimID not in (Select RepricingID From Repricing))