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

Ask an Expert

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

Write your message here..

Related Questions

What is alternate key, What is Alternate Key Alternate Key: This is t... 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

Assignment topic, assume we have the following apllicationthat model sccer ... 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, Illustrate the term-... 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 advantages of dbms over file oriented system, Explain the main ... Explain the main advantages of DBMS over File Oriented System ?

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

Describe difference between a one-to-many and a many-to-many, Describe the ... 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, What is substitutability? Any method of a cla... 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 containing name and number of department, Create a view emp_d... 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, What is database utility? Database utility is... 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, Define two-phase locking protocol. A... 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