MariaDB Question:

Please explain what is LEFT OUTER JOIN in MariaDB?

MariaDB Interview Question
MariaDB Interview Question

Answer:

MariaDB LEFT OUTER JOIN is used to return all rows from left-hand table specified in the ON condition and only those rows from the other table where the joined condition is satisfied.

LEFT OUTER JOIN is also called LEFT JOIN.

Syntax:
SELECT columns
FROM table1
LEFT [OUTER] JOIN table2
ON table1.column = table2.column;


Previous QuestionNext Question
Tell us what is the use of COUNT() aggregate function?Tell me how can you stop replication on all slave servers at the same point in time?