MySQL left join query

This is the one of method to joining two tables. It returns all rows from the left table, even if there are no matches in the right table

Syntax of the left join query:

SELECT column_name(s)
FROM table_name1
LEFT JOIN table_name2
ON table_name1.column_name=table_name2.column_name

Here is the two table with some data.

We want join these two tables by using left join.

Here is the left join sql query to display this and below that the output is listed.

SELECT names.id, names. f_name, places.n_place FROM names left join places on names.id = places.id

The result will show like this:

We named the above result table as Customer, then again we can join table Customer with the below mentioned table Order.

Table Customer

Table Orders

The left join query for  joining these two tables is shown below:

SELECT Customer.f_name, Customer.place, Orders.orderno
FROM Customer
LEFT JOIN Orders
ON Customer.id=Orders.id
ORDER BY Customer.f_name

The result of the above query display like below.

Related Posts

• MySQL inner join query
• MySQL right join query