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

Ask an Expert

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

Write your message here..

Related Questions

What are costs to be considere when transaction is roll back, What are the ... What are the costs to be considered when a transaction has to be rolled back when recovering from deadlock?         Ans: A few transaction will must rolled back (made a victim)

How does the two phase protocol ensure serializability, How does the two ph... How does the two phase protocol ensure serializability in database schedules?   Ans:  A transaction is termed to follow the two-phase locking protocol if all locking operations

Describe in brief about object oriented design, Describe about Object orien... Describe about Object oriented design Object oriented design is concerned with developing an object oriented model of a software system to implement known requirements. Many OO

Explain the lock based protocol, Lock Based Protocol A lock is nothing ... Lock Based Protocol A lock is nothing but a mechanism that tells the DBMS whether a particular data item is being used by any transaction for read/write purpose. As there are t

Name the various privileges in sql, Name the various privileges in SQL? ... Name the various privileges in SQL? A) Delete B) Select C) Insert D) Update

What is a query tree, What is a query tree?     Ans:  A query tree, as ... What is a query tree?     Ans:  A query tree, as well known as operator graph, is a tree data structure that corresponds to a relational algebra expression. It denotes the inpu

One to many - relationship cardinality, One-to-many : An entity in A is rel... One-to-many : An entity in A is related with any number of entities in B. An entity in B is related with at the most one entity in A. Example: Relationship between faculty and d

Describe embedded query language, Describe Embedded Query Language? Emb... Describe Embedded Query Language? Embedded Query Language - A query language (e.g., SQL) can be implemented in two ways. It can be used interactively or embedded within a host

Increased parallelism-data replication, Increased parallelism : Since the r... Increased parallelism : Since the replicated date has several copies a query can be distributed or can be answered from the smallest loaded site. Also, with more replicas you have

Client server databases, Client Server Databases- The concept behind the C... Client Server Databases- The concept behind the Client/Server systems is simultaneous, cooperative processing. It is an approach that presents a one systems view from a user's vie