Explain the difference between a LEFT JOIN and an INNER JOIN in the context of merging policyholder information with claims history.