Question d’entretien chez Cleveland Clinic

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