DBMS Joins: Inner Join & Outer Join

Lovesharma

Lovesharma

@lovesharma-77wnR0 • Oct 22, 2024
I learnt equi join & natural join. but what is inner join & outer join? Is equi join is also known as outer join & natural join as inner join??
Like 0 Replies 4

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

Sign up Log in

CrazyEngineers powered by Jatra Community Platform

  • Dancer_Engineer

    Dancer_Engineer

    @dancer-engineer-EJ8rGI • Jan 22, 2012

    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 <a href="https://en.wikipedia.org/wiki/Join_(SQL)" target="_blank" rel="nofollow noopener noreferrer">Join (Sql)</a> to understand with examples.
    0
  • Anoop Kumar

    Anoop Kumar

    @anoop-kumar-GDGRCn • Jan 23, 2012

    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.
    0
  • Dancer_Engineer

    Dancer_Engineer

    @dancer-engineer-EJ8rGI • Jan 23, 2012

    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.
    0
  • PraveenKumar Purushothaman

    PraveenKumar Purushothaman

    @praveenkumar-66Ze92 • Jan 25, 2012

    I guess this can explain you better... 😀
    [​IMG]
    0