Left Join in SQL | SQL Server Left Join

In Left Join in SQL articles, we learn in detail with an example and understand the difference between SQL LEFT Join and Left Outer Join.
The Left Join in SQL returns all records from the left table(table1) and the also matched records from the right table (table2). the results will become NULL from the right side (table2), if there no records will be matched.
In some databases, LEFT JOIN is called LEFT OUTER JOIN.

Syntax:

For each row from the left table (table1), the query compares it with all the rows from the Right table (table2).
Therefore, If a pair of rows causes the join predicate to evaluate to TRUE, the column values from these rows will be combined to form a new row which then included in the result set.

Furthermore, If a row from the left table (Table1) does not have any matching row from the right table (table2), then the query combines column values of the row from the table1 with NULL for each column values from the table2.

as a result, In short, you can understand that the LEFT OUTER JOIN clause returns all rows from the left table (Table1) and matching rows or NULL values from the right table (table2).

Example: Left Join in SQL

Let’s consider the following two demo tables,

Table1: Customers

Table2: OrderDetails

Left Join in SQL: Case-I

Now, let us see the Left join SQL, therefore these two tables using the JOIN as follows.
Therefore, In this case, we consider the Customers table is table1 and OrderDetails table considers the table2, both table are connected to each other. furthermore, let’s see the result:

Output:

Left Join in SQL: Case-II

Now, let us see the Left join SQL, therefore these two tables using the JOIN as follows.
Therefore, In this case, we consider the OrderDetails table is table1 and Customers table considers the table2, both table are connected to each other. furthermore, let’s see the result:

Output:

Difference Between SQL Left Join and SQL Left Outer Join

There is actually no difference between a SQL left join and a SQL left outer join, In some databases, therefore, both of them refer to the similar operation in SQL.
Let’s know the difference between through example:-

Sample Table: MedicalStore

Sample Table: Medicine

Therefore, you will that the very last row in the MedicalStore table, the Store ID does not exist in the Medicine table. Also, you can notice that the very last row in the Medicine table the value of Store ID is NULL and does not exist in the MedicalStore table. so, these facts will prove to be significant of the left join in SQL.
Therefore, the given below the SQL statement without using “outer” with “left join”.

Output:

Therefore, when we running the SQL Statement with the "outer" keyword, would give us the exact same results as per the SQL without the “outer”. therefore, the following below SQL statement is with "outer" with "left join".

Therefore, left outer join or left join retains all of the rows of the left table MedicalStore, regardless of whether there is a row that matches on the right table Medicine. Here is the output below, which is the same output as per the above SQL Statement.
Output:

Conclusion:

Furthermore, Now you should have a good understanding of how the LEFT JOIN SQL clause works and know how to apply the LEFT JOIN clause to query data from multiple tables. I hope you will enjoy it!, if have any query Email us, I will try to reach.