JOINS SQL/MSDN

JOINS: It is used to join two different tables having the same ColumnName.



Select * from Table1 JOIN Table2 on Table1.CommonColumn=Table2.CommonColumn where conditions

1. Inner Join: This is a normal join that joins the table and display all the satisfies thecondition.

2. Outer Join
  # left outer join
  #right outer join
  #full outer join

3 Cross Join

Equi Join

SELECT Column1, Column2 from Table1,Table2
WHERE Table1.Column1=Table2.Column2