Explain the outer join, Database Management System

Define Outer join

Outer join - If there are any type of values in the one table that do not have corresponding value(s) in the other, in an equi-join which will not be selected. Such types of rows can be forcefully selected by using the outer join, The corresponding columns for that row will comprise NULLs. In fact there are three forms of the outer-join operation: left outer join (_X), right outer join (X_) and full outer join (_X_).

Posted Date: 5/6/2013 5:46:26 AM | Location : United States







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

Write discussion on Explain the outer join
Your posts are moderated
Related Questions
What is Alternate Key Alternate Key: This is the candidate key which is not taken as the primary key of the table. They are named so because although not the primary key, the

assume we have the following apllicationthat model sccer team the games they play and the players inv each teamin the design we want to capture

Illustrate the term- Abstracting Out Common Behaviour Inheritance is not every time recognised during analysis phase of development, thus it is necessary to re-evaluate object

Explain the main advantages of DBMS over File Oriented System ?

Data Fragmentation "Fragmentation includes decomposing the data in relation to non-overlapping component relations". Why do we require fragmenting a relation?

Describe the difference between a one-to-many and a many-to-many relationship. Which logical data structures comprise one-to-many and which comprise many-to-many relationship?

What is substitutability? Any method of a class-say A can equally well be adjured with any object belonging to any subclasses B of A. This characteristic leads to code reuse, a

Create a view emp_dep containing e_name and number of dependents from the tables employee and dependent of (i) CREATE VIEW emp_dept AS SELECT ename, COUNT(*) FROM employee, dep

What is database utility? Database utility is the interface among the ABAP/4 Dictionary and the underlying the SAP system.

Define two-phase locking protocol. Ans: Two-phase locking is significance in the context of ensuring that schedules are serializable. The two-phase locking protocol defines a p