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

Construct a conceptual data model, Competition entrants can be either Indiv... Competition entrants can be either Individuals, or Teams. A Team is usually sponsored by a business, and, in that case, the team members would all wear T-shirts with the sponsoring

Produce a set of relations - normalisation, Produce a set of relations (equ... Produce a set of relations (equivalent to the Finkelstein entity list) in third normal form (3NF) from the following un-normalised relation. You must use the Finkelstein methodolog

Difference between internal tables and extra datasets, What is the differen... What is the difference between internal tables and extract datasets? The lines of an internal table always have the similar structure. By using extract datasets, you can ha

What is an index as defined in oracle, Normal 0 false false ... Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Explain interblock gap, Explain Interblock gap? Interblock Gap - A trac... Explain Interblock gap? Interblock Gap - A track of a disk is separated into equal-sized disk blocks. Blocks are separated through fixed-size gaps, called as interblock gaps th

Update operations, The Update Operations : Update operations are used fo... The Update Operations : Update operations are used for altering database values. The constraint violations faced by this operation are logically the similar as the problem faced

What is relational model feature, What is relational model feature? A r... What is relational model feature? A relational model feature is much more data independence than some other database models.

What is the use of rename operation, What is the use of rename operation? ... What is the use of rename operation? Rename operation is used to rename both relations and an attributes. It uses the as clause, taking the form: Old-name as new-name.

Importance of file organisation in database, Importance Of File Organisatio... Importance Of File Organisation In Database To execute a database efficiently, there are various design tradeoffs needed. One of the most vital ones is the file Organisation. F

Search the salary of employees who are not ‘analyst’ , Example- Search the ... Example- Search the salary of employees who are not 'ANALYST' but get a salary below than or equal to any people employed as 'ANALYST'. SELECT EMPNO, ENAME, JOB, SAL FROMEMP