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
DISADVANTAGES OF RDBMS

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

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 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 called as domain.

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 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 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 "Fragmentation includes decomposing the data in relation to non-overlapping component relations". Why do we require fragmenting a relation?

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