Although tables in SQL databases typically contain massive amounts of data, they’re not always in a format that can be used by data analysts. The data records in these tables need to be filtered ...
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.