RIGHT JOIN
Learn RIGHT JOIN (Joins, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction A RIGHT JOIN is the mirror image of LEFT JOIN: all rows of the right table are kept and unmatched left columns become NULL.