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

Your posts are moderated

Write your message here..

Related Questions

Name the metrics for selecting top algorithm, Name the metrics for selectin... Name the metrics for selecting top algorithm There are a number of metrics for selecting top algorithm: i) Computational complexity: Computational complexity refers to eff

The structured query language, The Structured Query Language INTRODUCT... The Structured Query Language INTRODUCTION Database is an organised set of information about an entity having controlled redundancy and serves numerous applications. DBMS

What are the reasons for having variable length records, What are the reaso... What are the reasons for having variable length records? What are the various ways to store variable length records? Variable-length records arise in a database in various wa

What is a database, What is a Database? To know what database is, we ha... What is a Database? To know what database is, we have to start from data, which is the basic building block of any DBMS. Data: Facts, figures, statistics etc. having no pa

Unnormalize form, employee(empid,empname,dept,telno,mobno, add,sssno,tinno,... employee(empid,empname,dept,telno,mobno, add,sssno,tinno,WEdates,WEcomp,WEadd,WEpos,WEres) this is a employee record which is need to be normalize.the WE means work experience

Design and building a distributed information system, prototype of a distri... prototype of a distributed information system for a national car part retail outlet chain.

E r diagram, how to make an e r diagram? how to make an e r diagram?

ERD, entity relationship diagram about finance entity relationship diagram about finance

desirable properties of decomposition, Desirable Properties Of Decompositi... Desirable Properties Of Decomposition Decomposition is a process of dividing a relation into its projections that will not be disjoint. Please remind the Relational projection

Define direct file organization, Define Direct file organization? The d... Define Direct file organization? The direct file organization is employed to enhance the performance in accessing the records than sequential file organization. In direct file