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
Explain the Attribute inheritance Ans: Throughout the rendering of the objects in a view, attribute sets of objects higher in the view hierarchy are inherited via objects below

Describe the Menu based interfaces for web clients or browsing? Menu-Based Interfaces for Web Clients or Browsing - These interfaces present the user along with lists of option

The natural join is equal to which product? The natural join is equal to Combination of projection and Cartesian product

What is a block and a block number? A block is a contiguous sequence of sectors from a single track of one platter. Every request specifies the address on the disk to be refere

What is candidate key? Candidate Key - A candidate key of an entity set is a minimal superkey, which uniquely identifies each row in the relation.

In this practical assignment, we will run through a complete database application development cycle, starting with the schema design, from an initial data import to database applic

Consider the following relational schema: PERSON (SS#, NAME, ADDRESS) CAR (REGISTRATION_NUMBER, YEAR, MODEL) ACCIDENT (DATE, DRIVER, CAR_REG_NO) OWNS (SS#, LICENSE) Constru

Which product produces the relation that has attributes of R1 and R2 ? Cartesian product produce the relation which has attributes of R1 and R2

Describe integrity and security? a)      Domain constraint b)      Referential integrity A value that appears in one relation for a given set of attributes also appear fo

The advantages of a database management system (DBMS) include :- Data integrity and elimination of duplication.