MariaDB RIGHT OUTER JOIN is used to return all rows from right-hand table specified in the ON condition and only those rows from the other table where the joined fields are satisfied the conditions.

MariaDB RIGHT OUTER JOIN is also called RIGHT JOIN.

Syntax:

SELECT columns

FROM table1

RIGHT [OUTER] JOIN table2

ON table1.column = table2.column;