What is outer join, Database Management System

What is Outer join?

 They can be employed while we want to keep all the tuples in R, or all those in S or all those in both relations in the result of the JOIN in spite of of whether or not they have matching tuples in the other relation.

Posted Date: 5/6/2013 3:28:19 AM | Location : United States







Related Discussions:- What is outer join, Assignment Help, Ask Question on What is outer join, Get Answer, Expert's Help, What is outer join Discussions

Write discussion on What is outer join
Your posts are moderated
Related Questions
Write short notes on transaction state? A transaction may not always complete its implementation successfully such a transaction is termed aborted A transaction must be in o


What is called as an N-way merge? The merge operation is a generalization of the two-way merge used by the standard in-memory sort-merge algorithm. It merges N runs, so it is k

Determine the steps of path in association network You can analyse use of paths in association network in the following steps:  Examine every operation and see what asso

Example -GRANT CREATE SESSION TO MCA12; (This command gives system level permission on creating a session - not portable) GRANT SELECT ON EMP TO MCA12; (Object level permi

In which form of relational database developer refers to a record? In a tuple form of relational database developer refers to a record.

Illustrate the Deployment Diagram A deployment diagram shows all nodes on network, their processor execution and interconnections. In a dynamic model, this is used to represen

What is Thread splitting A thread of control is a path by which a set of state diagrams on that a single object is active at a time. Objects are shared between threads

I want a professional with strong IT background who provide me timely assignments Project Description: I want a professional who can do my assignments for my major i.e. Infor

Give the general form of SQL query? Select  A1, A2............., An From  R1, R2..............., Rm Where  P