"If at first you don't succeed; call it version 1.0" :-Unknown

Pages

Friday, May 27, 2011

Left Outer Join, Right Outer Join and Full Outer Join.

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.


Have a nice day... 'N happy Coding :)
Posted by

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)