Explain the difference between a left join and an inner join in SQL, and describe a healthcare scenario where you would use each at Komodo Health.
