Explain the difference between a LEFT JOIN and an INNER JOIN using a scenario involving patient profiles and medical claims tables at Aetna.
