krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 20th, 2008

 

Left outer join returns rows that satifies the join condition + rest of the rows from the left table.

Right outer join returns rows that satisfies the join condition + rest of the rows from right table.


The difference between join and set operators is

Join is used to join columns from two or more tables.

Set operators are used to get similar type of information  from two or more tables.

krishnaveni_g

 Profile Answers by krishnaveni_g 

• Jul 14th, 2008

 

By using equi join and union we can get only matched data from both tables.  But we can get unmatched data by using left outer join, and right outer join.

Ex: select e.emp_name,e.salary, d.department_name from employees e, departments d where e.department_id = d.department_id

The above Example is for equi join.

Ex: select e.emp_name,e.salary, d.department_name from employees e, departments d where e.department_id(+) = d.department_id
 
By using above example we can get mathced data from both tables and also unmathced data from department table.

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

join is a concept to retrive the data from tqo or more tables.
1. equi join-gives the matching record form both the table
2.outer join-gives matching as well as other records -

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

Using Equi Join with Union we can do the outer join then why we need to go for Outer Join -- increase the performance

aytasirs

 Profile Answers by aytasirs 

• Nov 15th, 2012

 

Left outer Join fetch all the records from Left side Table(Only Condition satisfied records from right side table) where as Right Outer Join fetch all the records from Right side Table(Only Condition satisfied records from Left side table).