What is the difference between a left join and an inner join, and when would you use each in a marketing context?