MariaDB Left Outer Join

by Online Tutorials Library July 14, 2022

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:

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

Image representation:

MariaDB Left outer join 1

Example:

 SELECT Students.student_id, Students.student_name,  Students.student_address,  Employee2.salary, Employee2.emp_address FROM Students  LEFT JOIN Employee2 ON Students.student_id = Employee2.emp_id; 

Output:

MariaDB Left outer join 2

Next TopicMariaDB Right Outer Join

MariaDB Left Outer Join

MariaDB LEFT OUTER JOIN

System Testing

Bar Graph

You may also like