Glossary: SQL Beyond the Basics

RIGHT JOIN

Keeps every row of the second table. Most people swap the tables and write a LEFT JOIN instead.