Javatpoint Logo
Javatpoint Logo

MariaDB LEFT OUTER JOIN

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:

Image representation:

MariaDB Left outer join 1

Example:

Output:

MariaDB Left outer join 2




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA