JOIN clause is used to combine rows from two or more tables, based on a common field between them. Below is list of Different SQL JOINs: INNER JOIN: Returns all rows when there is at least one match in BOTH tables LEFT JOIN: Return all rows from the left table, and the matched rows from the right table RIGHT JOIN: Return all rows from the right table, and the matched rows from the left table FULL JOIN: Return all rows when there is a match in ONE of the tables

JOINS the join means the relation between two table

Joins are basically use in database for getting values(rows/columns) from more than one tables.

Joins are used to get the data from More than one table at a time. it may based on some condition or may not. in SQL server we have three types of joins 1.Inner Join 2.cross Join 3.Outer Join.

join used to retrieving data from more than one table.

A JOIN clause is used to combine rows from two or more tables, based on a common field between them

http://dotnet-munesh.blogspot.in/2013/12/joining-in-sql-server.html

A Join combines columns and data from two or more tables (and in rare cases, of one table with itself called as self join). So basically there are 4 joins Inner join Outer Join Cross Join Self Join http://technet.microsoft.com/en-us/library/ms191472(v=sql.105).aspx

A Join combines columns and data from two or more tables (and in rare cases, of one table with itself).