• The FULL OUTER JOIN keyword retrieves all records when there is a match in either the left (table1) or the right (table2) table records.

SELECT column_name(s)
FROM table1
FULL OUTER JOIN table2
ON table1.column_name = table2.column_name
WHERE condition;

• Here is a portion from the "Wikitechy" table:

• Here is an excerpt from the " Student Detail " table:

SELECT tbl_Wikitechy.Student_Name, tbl_Student_Detail .Student_Id
FROM tbl_Wikitechy
FULL OUTER JOIN tbl_Student_Detail ON tbl_Wikitechy.Student_Id=tbl_Student_Detail.Student_Id
ORDER BY tbl_Wikitechy.Student_Name;