Monthly Archives: October 2009

SQL Joins, Inner Join, Outer Join, Cross Join

Articles

First of all take a look on the names of different types of joins in SQL.

1.    Inner Join

  • Self Join
  • Equi Join
  • Natural Join

2.    Outer Join

  • Left Outer Join
  • Right Outer Join
  • Full Outer Join

3.    Cross Join

Joins in SQL Server allows the retrieval of data records from one or more tables having some relation between them. Logical operators can also be used to drill down the number of records to get the desired output from sql join queries.
Continue reading →