JOINS in SQL SERVER and Different types of JOINS in SQL Server

JOINs allows the retrieval of data records from one or more tables having some realrion between them.
There are 3 types of JOINS in sql server.
1)INNER JOIN
2)OUTER JOIN
    a)LEFT OUTER JOIN
    b)RIGHT OUTER JOIN
    c)FULL OUTER JOIN
3)CROSS JOIN

Refer the Example :
INNER JOIN Example in SQL SERVER
LEFT OUTER JOIN Example in SQL SERVER 2005
RIGHT OUTER JOIN Example in SQL SERVER 2005
FULL OUTER JOIN Example in SQL SERVER 2005
CROSS JOIN Example in SQL SERVER 2005
SELF JOIN Example and scenario in SQL SERVER 2005



No comments:

Post a Comment