Описание тега right-join
The RIGHT JOIN keyword will return all the rows from the right table, even if there are no matches in the left table.
SQL RIGHT JOIN ON returns the rows of INNER JOIN ON plus unmatched right table rows extended by NULLs. A consequence is that it returns all the rows from the right table at least once even if there are no matches in the left table. See examples here.