Difference between left outer join and right outer join, Database Management System

Difference between LEFT OUTER JOIN and RIGHT OUTER JOIN

In left outer join tuples from the left-hand-side relation which do not match any tuple in the right-hand-side relation are padded along with nulls and are added to the result of the left outer join. Likewise, in right outer join tuples from the right-hand-side relation which do not match any tuple in the left-hand-side relation are padded along with nulls and are added to the result of the left outer join.

Posted Date: 5/6/2013 3:45:38 AM | Location : United States







Related Discussions:- Difference between left outer join and right outer join, Assignment Help, Ask Question on Difference between left outer join and right outer join, Get Answer, Expert's Help, Difference between left outer join and right outer join Discussions

Write discussion on Difference between left outer join and right outer join
Your posts are moderated
Related Questions
Evaluate, compare and contrast the two methods of relational database design namely top down method and Bottom up method. What will be your choice if you are asked to select a meth

Project Description: I need a point of sale for motels. It needs to run on windows and requires being network able so that we can have more than one computer using it at once.

What are partial, alternate,, artificial, compound and natural key? Partial Key: It is a set of attributes that can uniquely recognize weak entities and that are related to s

Define granularity, hierarchy of granularity of locks & multiple granularity locking. Explain the modified two phase locking along with multiple granularity locking. Ans: The s

Explain the function of input controls. Identify four types of input control and explain the function of each. Provide an example of a data integrity error that could occur i

What are the types of storage devices? Primary storage Secondary storage Tertiary storage Volatile storage Nonvolatile storage

Deadlock And Its Prevention: As seen earlier, though two phase locking protocol handles the trouble of serialisability, but it causes some troubles also. For instance, consider th

Explain group By clause in SQL? Group By clause in SQL: The GROUP BY clause can be used in a SELECT statement to collect data across multiple records and group the results thro

What does authentication refer? Authentication refers to the task of verifying the uniqueness of a person.

brief history,definition,current trends and future trends if any of data fragmentation