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




Youtube For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA