What is a join and explain different types of joins

What is a join and explain different types of joins.

Joins are used in 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 JOINs, OUTER JOINs, CROSS JOINs.
OUTER JOINs are further classified as LEFT OUTER JOINS, RIGHT OUTER JOINS and FULL OUTER JOINS.

What are different Types of Join?

A join is typically used to combine results of two tables. A Join in SQL can be:-
- Inner joins
- Outer Joins
- Left outer joins
- Right outer joins
- Full outer joins
- Inner join

An inner join looks for matching records taken from one table from another.
A left outer join limits results to the table in left of JOIN.
A right outer join limits results to the table in right of JOIN.
Full outer joins are the combination of left and right outer joins
What is a self join in SQL Server?
Two instances of the same table will be joined in the query...
Sql server - Explain the various types of concurrency problem.
Types of concurrency problem:- Lost or buried updates: - When the same row is selected for updates by two or more transactions and updates the row based on the value originally selected.........
Sql server - Describe optimistic and pessimistic concurrency
Optimistic concurrency: - Assumes that a resource is likely to be available at all times. This means that resource locking is very unlikely......
Post your comment
Discussion Board
Joins in SQL Server
This is the best one article so far I have read online. I would like to appreciate you for making it very simple and easy. I have found another nice post related to this post over the internet which also explained very well. Please check this helpful link...
http://mindstick.com/Articles/32e0f4c1-7fd1-4c86-b3ec-4dc86037045d/?Join%20in%20SQL%20Server

Thanks
Pankaj Singh 12-27-2011