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

RDBMS, DISADVANTAGES OF RDBMS DISADVANTAGES OF RDBMS

Describe queries with complex types, Describe queries with complex types? ... Describe queries with complex types? The present extension of the SQL query language deal with the complex type Let us start with the simple example: Find the title and t

Datawarehouse, 1) Define a job scheduling strategy that will meet business ... 1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

I want a professional with strong it background, I want a professional with... I want a professional with strong IT background who provide me timely assignments Project Description: I want a professional who can do my assignments for my major i.e. Infor

A set of possible data values is called, A set of possible data values is c... A set of possible data values is called? A set of possible data values is called as domain.

Discuss the method for a hash file to expand shrink dynamic, Discuss the me... Discuss the methods for a hash file to expand and shrink dynamically. What are the advantages and disadvantages of each? The hashing methods that permit dyanamic file expansi

The result of the union operation between r1 and r2, The result of the UNIO... The result of the UNION operation between R1 and R2 is a relation that includes? The result of the operation between R1 and R2 includes all the tuples of R1 and R2 which have c

Define the concept of object diagram, Define the concept of Object Diagram ... Define the concept of Object Diagram An object diagram shows a set of the objects and their relationships with each other at a point of time. In a static view, object diagram

Data fragmentation, Data Fragmentation "Fragmentation includes decompos... Data Fragmentation "Fragmentation includes decomposing the data in relation to non-overlapping component relations". Why do we require fragmenting a relation?

What is alternate key, What is Alternate Key Alternate Key: This is t... What is Alternate Key Alternate Key: This is the candidate key which is not taken as the primary key of the table. They are named so because although not the primary key, the