- SQL Introduction
- SQL Select Query
- SQL Where Query
- SQL Joins Query
- SQL Update
- SQL Count
- SQL Sum
- SQL Operators
- SQL Like
- SQL Group By
- SQL Insert Into
- SQL Inner Join
- SQL Left Join
- SQL Right Join
- SQL Full Join
- SQL Exists
- SQL Null
- SQL Stored Procedures
- SQL Any
- SQL Self Join
- SQL Top Statement
- SQL Delete
- SQL Order By
SQL Left Join.
LEFT JOIN in SQL allows to retrieval of all records from the left table and only the matching records from the right table.
When there is no matching record in the right table, SQL will return NULL for columns from the right table.