Can u explain Joins in SQL with examples?

See excellent artical from this link.

http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/

1. Equi Join
2. Natural join
3. Cross Join
   

1. Left outer
2. Right outer
3. full outer Join

Hi,

Join: Join is nothing but retrieve the data from multiple table .
Joines are classified into 4 types.
1) Inner join.
2)Outer join.
3)Cross join.
4)Self join.
1) Inner join: Inner join is used for select matched rows as well as unmatched rows from both the tables
Ex :
select empname,empid from emp table inner join on dept table where emptable.empid = depttable.deptid
2) Outer join:
It will retrive only matched records from both the tables .it is again classified into two types
a)Left outer:Left side table select all record and right side table select only matched records.
Ex:
select empname,empid from emp table Left join on dept table where emptable.empid = depttable.deptid
b)Right outer: Reverse of Left join
3)Cross join: cross join is used for the cross the two table data.
4) self join:joining it self .
  

Hi Poonam Jee.

       Joins retrieve data more than one tables on the basis of conditions.

        Types of Joins:-

      1) Inner Joins.

     2) Outer Joins.

     3) Self Joins.

     4) Cross Joins.

     5) Equi Joins.

         etc.

   Note:-Join implicitly means Inner Join

             Outer Join must be supplied with either of left, right or full Join

   Sanjeev Kumar singh

         Thanks.

 EmailId:- [email protected]