SQL LEFT JOIN

SQL Tutorial » SQL LEFT JOIN

The LEFT JOIN returns all records from the left table (table1), even if there are no matches in the right table.

This means that a left join returns all the values from the left table, plus matched values from the right table or NULL in case of no matching join predicate.

Syntax:

Let's look at the Table1 "Customer" table: We will have four columns as: "Customer_ID", "Name", "Age" and "Value_salary"

Table 2 − "Orders" Table is as follows.:

Now, let us join these two tables Customer and Orders using the LEFT JOIN as follows:

Output displayed:

Related subjects:
How to create database phpmyadmin? Select data form database Insert into SQL SQL update PSql delete row

Tags: SQL LEFT JOIN: example, vs right join, select, nultiple tables, vs left outer join, vs inner join, on multiple columns, with where clause, right join, duplicate row,
What is a SQL LEFT join?
Is Left join the same as left outer join?
How do I join two tables with LEFT join?
When to use left join vs Right join?

Several operators can be used to join tables, such as =, <, >, <>, <=, >=, !=, BETWEEN, LIKE, and NOT; they can all be used to join tables.

WHERE clause and ON clause are not the same.

AND

The first will return an order and its lines, if any, for order number 12345. The second will return all orders, but only order 12345 will have any lines associated with it.