Can you explain the difference between a left join and an inner join in SQL, and when would you use each?
