Origami Risk interview question

What’s the difference between an inner join and left join in SQL?