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