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

Ask an Expert

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

Write your message here..

Related Questions

Write short notes on transaction state, Write short notes on transaction st... 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 a transaction? and how does it differs from update, wh wh

What is called as an n-way merge, What is called as an N-way merge? The... 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, Determine the steps of ... 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 of grant create session to mca12, Example -GRANT CREATE SESSION TO ... 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, In which form of rel... 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, Illustrate the Deployment Diagram A... 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, What is Thread splitting A thread of cont... 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, I want a professional with... 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, Give the general form of SQL query? ... Give the general form of SQL query? Select  A1, A2............., An From  R1, R2..............., Rm Where  P