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

Your posts are moderated

Write your message here..

Related Questions

What is datawarehousing What is DataWarehousing? Subject-oriented, meaning that the data in the database is organized so that all the data elements relating to the similar real-wo

Describe domain constraints Describe domain constraints. Domain constraints contain entity integrity and referential integrity. The domain is a set of values that might be assigned to

Whta is the advantage of the database ma... Whta is the advantage of the database management approach? The advantage of the database management approach is data is integrated and can be accessed by mu

Candidate keys Super keys of a relation can have extra attributes. Candidate keys are minimal super key, i.e. such a key have no extraneous attribute. An attribute is known as

What is enterprise resource planning What is Enterprise Resource Planning (ERP), and what kind of a database is used in an ERP application? Enterprise Resource Planning (ERP) is an information

Prepare a gantt chart for the stock cont... Prepare a gantt chart for the stock control project: Scenario Lucas-TVS is the Leader in Auto Electricals in India today with 50 years

Shared lock or read lock Shared lock or Read Lock It is requested by a transaction that needs to just read the value of data item. A shared lock on a data item does not perm