Outer Join--Its a join condition used where you can query all the rows of one of the tables in the join condition even though they don’t satisfy the join condition.
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.
