Why left join is used in SQL?

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.