Cleveland Clinic interview question

How do you normalize tables? Whats the difference between JOIN and LEFT JOIN in SQL?