DBMS Joins: Inner Join & Outer Join

Replies

• 

  Dancer_Engineer

  Lovesharma

  Is equi join is also known as outer join & natural join as inner join??

  Natural join is a subset of equi join which in turn is classified under inner join.
  
  
  

  Lovesharma

  but what is inner join & outer join?

  Inner Join: Inner Join returns the set of only those records which matches in one table with another.
  Outer Join: Outer Join return you the set of all matching records from both table. The Outer Join does not requires each records to be matched in both the tables.
  
  Read Join (Sql) to understand with examples.
• 

  Anoop Kumar

  If you are matching two table usnig a column or just added two tables in from clause(but no column compare) then automatically inner join will be applied.
  Ex: select * from table Ta,Tb;
  then inner join will be applied on Ta,Tb.
• 

  Dancer_Engineer

  ianoop

  If you are matching two table usnig a column or just added two tables in from clause(but no column compare) then automatically inner join will be applied.
  Ex: select * from table Ta,Tb;
  then inner join will be applied on Ta,Tb.

  Yes, Inner join is a default join.
• 

  PraveenKumar Purushothaman

  I guess this can explain you better... 😀