sithusithu

 Profile Answers by sithusithu 

• Jan 24th, 2006

 

A join that links two tables, one of which has rows that do not match those in the common column of the other table

 

Cheers,

Sithu

Mainak Aich

• Mar 2nd, 2006

 

Suppose we have two tables.Now with the help of outer join,we can add those rows of a table which doesn't matchs the join condition.e.gtable a table bname roll name roll m 1 m 1n 2 n 2o 3 g 7p 4 h 8so the sql for adding all information of table a into the result will be:select name,roll from a,b where a.name=b.name(+);just run the sql to see the result .you can alternatively use the + on the left side to view another result.

Rohan Deshpande

• Jan 29th, 2007

 

when the rows that don't meet the join condition. then we use outer join...

madhug56

 Profile Answers by madhug56 Questions by madhug56

• Jun 5th, 2007

 

1. An outer join is extension for a simple join.
2. It returns all the rows returned by the simple join as well as those rows form one table that do not match any row from other table.
   

Sujatars

 Profile Answers by Sujatars 

• Aug 8th, 2007

 

The outer join returns all the rows from both tables even though they don't meet the join condition.

patilpravin_1981

 Profile Answers by patilpravin_1981 

• Jan 29th, 2008

 

outer join is that type of jon which retrives the matach & alson unmatached recores also from the tables

ankitagujrati28

 Profile Answers by ankitagujrati28 

• May 3rd, 2010

 

OUTER JOIN is the way to collect records in case of lack of true join condition.