Clear all

mysql left join

Posts: 74
Topic starter
Joined: 11 months ago

What is MySQL left join?

Topic Tags
1 Reply
Posts: 48
Eminent Member
Joined: 11 months ago

 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.

Joins in MySQL | Learn Top 6 Most Useful Types of Joins in MySQL