#sql
SQL Outer Join in Hindi with syntax and example gives you the detailed explanation of how can you retrieve data from two tables using outer join.
An OUTER JOIN is a type of join that allows you to include not only the rows that match between the two tables, but also the unmatched rows from one or both of the tables.
Syntax:
SELECT table1.column1, table2.column2
FROM table1
LEFT [OUTER] JOIN table2
ON table1.column_name = table2.column_name;
For more: https://www.javatpoint.com/sql-outer-...