CrazyEngineers
CrazyEngineers

  • DBMS Joins: Inner Join & Outer Join

    Lovesharma

    Lovesharma

    @lovesharma-77wnR0
    Updated: Oct 22, 2024
    Views: 1.1K
    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??
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies

  • Dancer_Engineer

    Member • 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.
    Are you sure? This action cannot be undone.
    Cancel

  • Anoop Kumar

    Member • 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.
    Are you sure? This action cannot be undone.
    Cancel

  • Dancer_Engineer

    Member • 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.
    Are you sure? This action cannot be undone.
    Cancel

  • PraveenKumar Purushothaman

    Member • Jan 25, 2012

    I guess this can explain you better... 😀
    [​IMG]
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register