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

Enforce referential integrity, Use Access 2007 to create a database calle... Use Access 2007 to create a database called UniLib.mdb. - this file should be created on your personal drive at the university (or C: if you're using Access 2007 at home) and t

What are stored-procedures, What are stored-procedures? And what are the ad... What are stored-procedures? And what are the advantages of using them? Stored procedures are database objects that perform a user defined operation. A stored procedure can have

Explain the need for the bcnf normal form, Surgeons identified by doctor ID... Surgeons identified by doctor ID (DOCID) operate on patients identified by patient ID (PATID) in operating theaters identified by room numbers (ROOMNO). Each surgeon can operate on

Write short note on events, Write short note on Events Events consist ... Write short note on Events Events consist of inputs, interrupts, decisions and actions performed by any external device or users. Every event always has a sender and receiver.

Describe the capabilities offered via mysql client apis, Describe the capab... Describe the capabilities offered via MySQL client APIs? . • Checking for errors. . • Connecting to the MySQL server, selecting a database, disconnecting from the server

What is a sub-query, (a) What is a Sub-Query? (b) What is the differen... (a) What is a Sub-Query? (b) What is the difference between a scalar sub-query and a tabular sub-query? (c) Write an equivalent SQL statement to get the Name of Product wh

What are composite attributes, What are composite attributes? Composite... What are composite attributes? Composite attributes can be separated in to sub parts.

Designing the hierarchy of a ldb?, What sorts of tables one can se in desig... What sorts of tables one can se in designing the hierarchy of a LDB? Tables, which are having Foreign Key relations.

Improved performance, Improved performance: As the data is located near the... Improved performance: As the data is located near the site of its demand, and given the inherent parallelism because of multiple copies, speed of database access may be good for di

Normalization, in case of functional dependencies how we get the higher nor... in case of functional dependencies how we get the higher normal form.