Dot net and sql server questions


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.
example
SELECT *
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



Reference: http://en.wikipedia.org/wiki/Join_(SQL)


Related Articles

Object Serialisation in dot net

This article provides an overview of the serialization used in Microsoft .NET and the usage of the same.For example, serialization is used to save session state in ASP.NET and to copy objects to the clipboard in Windows Forms. It is also used by remoting to pass objects by value from one application domain to another.

More articles: Dot Net

Comments

Author: srirama11 Feb 2014 Member Level: Gold   Points : 2

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.



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: