Join Clause In Programing With Example

in this topic i am explain about join Clause fetch records from multiple table.

What is Join 
SQL join clause use for fetch record from two or more table base on common fields.
in SQL  There are four types of Joins.
1) Inner-Join
    i-Equi-Join
   ii-Natural Join
2) Outer-Join
   i-Left outer join
  ii-Right outer join
 iii-Full outer join
3) Cross Join 
4) Self Join

Using the join
 join is very useful for fetching records from different tables with reference to common columns between them.
 Example: