Julia Kagan is a financial/consumer journalist and former senior editor, personal finance, of Investopedia. Ebony Howard is a certified public accountant and a QuickBooks ProAdvisor tax expert. She ...
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.