Answer:
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;
MariaDB RIGHT OUTER JOIN is also called RIGHT JOIN.
Syntax:
SELECT columns
FROM table1
RIGHT [OUTER] JOIN table2
ON table1.column = table2.column;
| Previous Question | Next Question |
| Tell me what is the use of ORDER BY clause in MariaDB? | Please explain what is the use of LIKE clause in MariaDB? |