Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.
LEFT OUTER JOIN - This returns all the matching rows and the unmatched rows of the left table of the SQL code.
RIGHT OUTER JOIN - This returns all the matching rows and the unmatched rows of the right table of the SQL.
FULL OUTER JOIN - This returns all the matching and unmatched rows from both the tables.
