Types of Joins

[jyoti_02]

I want to know some thing related to Joins?
How many types of joins?
whats commands we used for Joins?
Every part related to Joins...

[krishnaindia2007]

I want to know some thing related to Joins?
How many types of joins?
whats commands we used for Joins?
Every part related to Joins...

>>want to know some thing related to Joins?
Join is used to combine columns from two or more tables.


>>How many types of joins?
Types of join

1. Equi join or inner join :- In equi join we combine columns from two or more tables using = operator.

2. Non equi join :- Two or more tables joined using other than = operator. It is used when there is no column column in tables.

3. Self Join :- Joining table to itself is called self join.

4. Outer Join :- It extend the results of inner join. Outer join retrieves the rows returned by equi join as well as rows do not match any row from other tables.

Types of outer join
·Left Outer Join: Returns rows from both tables that satisfy the join condition, and the rest of rows from the first (left) table.

·Right Outer Join: Returns rows from both tables that satisfy the join condition, and the rest of rows from the second (right) table.

·Full Outer Join: Returns rows from both tables that satisfy the join condition, the rest of rows from the first (left) table, and the rest of rows from the second (right) table.

To know more details about join follow the link