Many people seem to become filled with anxiety over the word “normalization.” Mentioning the word causes folks to slowly back away toward the exits. Why? What might have caused this data modeling ...
RIGHT JOIN (or RIGHT OUTER JOIN): It’s the opposite of a LEFT JOIN. It keeps all rows from the right table and matches from the left. Less common than LEFT JOIN, but good to know it exists.