SQL SERVER JOINS

SQL SERVER JOINS

JOINS are used to combine 2 or more tables which has common columns.

  SQL SERVER  has following Joins

•  INNER JOINS
• OUTER JOINS
  • FULL
  • LEFT
  • RIGHT
• SELF JOIN
• CROSS JOIN 

TAGS:

SQL SERVER JOINS,SQL SERVER INNER JOIN,SQL SERVER FULL OUTER JOIN,SQL SERVER LEFT OUTER JOIN,SQL SERVER RIGHT OUT JOIN,SQL SERVER SELF JOIN,SQL SERVER CROSS JOIN,SQL SERVER CARTESIAN PRODUCT JOIN.