Joins in Sql Server Queries?

Joins are used in SQL queries to explain how different tables are related. Joins also let you select data from a table depending upon data from another table.

Types of joins: INNER JOIN, OUTER JOIN, CROSS JOIN. OUTER JOIN are further classified as LEFT OUTER JOINS, RIGHT OUTER JOINS and FULL OUTER JOINS.

Joins are used to retrieve data from more than one table based a common field. Based on ur query, the output is taken from 2 or more tables

Hi,
Your article are really awesome.actually i was in search for some good articles on sql joins and finally i got one. I got another nice post related to this post over the internet which is also having wonderful explanation on sql joins, you may check it by visiting this url..

http://mindstick.com/Articles/88150490-6f81-4728-a8cb-650d3097e3fa/?JOINS%20in%20SQL%20Server

Thanks