mysql left join

 MySQL left join

In MySQL, a Left Join is used to query records from multiple tables. As a result, the Left Join clause returns all rows from the left table and matched records from the right table, or Null if no match is found. This is also known as a Left Outer Join clause.

Left joins are used when a user wants to access only the left table's data. The left join combines not only the left table's rows but also those that match the right table.

The join returns all the rows of the table on the left side of the join as well as the rows from the table on the right side of the join. For the rows where there is no matching row on the right side, the result-set will contain null. In addition to LEFT JOIN, LEFT OUTER JOIN is also used. Syntax: SELECT table1.