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
What are audit trails? An audit trail is a log of all alters to the database along with information like which user performed the change and when the alter was performed.

In which relational modes, cardinality is termed? Answer : Cardinality is termed in a number of tuples relational modes.

What is known as clustering file organization? In the clustering file organization, records of several dissimilar relations are stored in the similar file.

Ways for Selecting Data Structure Algorithms operate on data structure. Therefore, selection of the best algorithm means selecting the best data structure from whole bunch. Th


What is trigger?  Triggers are statements that are executed automatically by the system as the side effect of a modification to the database.

Define Thomas write rule Thomas' write rule: The Thomas' write rule is a modification of timestamp-ordering protocol for concurrency control. Assume that transaction T i issue

Consistency error : These errors happen due to the inconsistent state of database caused may be due to wrong implementation of commands or in case of a transaction abort.  To overc

Normalize the given relation to 3NF, justifying each step

What are deadlocks?  How can they be avoided?  Ans: Deadlock considers to a particular condition when two or more processes are every waiting for another to release a resource,