Difference between left outer join and right outer join
The answer is:- The results obtained from left outer join contains all the records from the left table even if they are not matching or NULL and matching record from right table. If the right table contains more than one record and left contains one record, the results from the left table will be repeated for every right table record.
Where as right outer join contains all the records from the right table and matching records from the left table.
FROM employee LEFT OUTER JOIN department
ON employee.DepartmentID = department.DepartmentID
Here all the records from employee table will be shown with matching records from department table.
For more information on join refer this link
More articles: Dot Net
if we strictly speaks lets put in this way Left outer Join means the Left part of the table will be viewed as it is and with that it will display match columns of the Right table.