SQL FULL OUTER JOIN
SQL JOINS are used to combine records from two or more tables in a database.
To apply a join in both tables, it is necessary to have at least one relative(common) column.
We can combine up to 32 tables in a single query.
Syntax:Â Â Â Â
        SELECT table1.column1 , table2.column2 FROM table1.columnname JOIN table2.columnname ;Â
Let’s understand the FULL OUTER JOINÂ with an example. For Demo, we will be using the Emp and Project Tables.
     Table Emp
Table Project
To generate a result set through joins, we can utilize both the emp and project tables.
The relative column between the two tables is Ecode.
FULL OUTER JOIN returns all records when there is a match in either the left or right table.
 FULL OUTER JOIN Example :
  Objective: In this example, we will retrieve all the records when there is a match in the left table(Emp) or right                     table(Project).
            SELECT e.Ecode, e.FirstName, e.LastName, p.Project FROM Tbl_Emp as e                                                                                      FULL JOIN Tbl_Project as p                                                                                on e.Ecode = P.Ecode;
  Output:
