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: