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.
Metro journalists select and curate the products that feature on our site. If you make a purchase via links on this page we will earn commission – learn more ...