SQL LEFT JOIN
In SQL, LEFT JOIN keyword returns all records from the left table as well as all matching records from the right table, even if there are no matches in the right table. That means if the ON clause matches 0 (zero) records in the right table, the join will still return a row in the result but with NULL in each column from the right table.
SQL Left Join Query Syntex
SELECT column_name(s)
FROM left_table
LEFT JOIN right_table
ON left_table.column_name = right_table.column_name;
Note Points
- SELECT, FROM, LEFT JOIN, ON are SQL query syntax.
- Two tables are used in this query left_table TABLE-1 and right_table TABLE-2.
- column_name(s) are belong to specific tables.