What is the difference between left join and inner left join?

Join : Retrive Data from one or More that one table on the certain Login is Call Join,

 

1. Inner join is call Simple join, after satisfaction of both row data will retrive.

2. Left Join : Retrive Data Even Not Match On Right Table Row

 

we have2 Table 

1. tblEmployee

EMPID, EMPNAME

2. tblempDetails

EMPID, Address

.

example : Inner Join

Condition to find the emploee who have address details.

then write Inner Join

Example Left Join

. Condition to find the all emploee who have  or Not have address details, 

 

A left join always retrieves the matching rows of some specific column between table A and table B.
An inner left join retreives all the rows from table a but only the matching rows from table B.

They are equal to each other. There is absolutely no difference between them. They are equal in performance as well as implementation. JOIN is actually shorter version of INNER JOIN.

 

Example :

An INNER JOIN will retrieve all records from both tables that have matching values for whatever column you're joining them on. Records from either table that don't match will not be retrieved. A LEFT JOIN will retrieve all records from the left (first) table, and only the records from the second table with matching values for the joining column, filling in any empty spaces with NULL values