SQL Joins

http://www.aspdotnet-suresh.com/2011/12/different-types-of-joins-in-sql-server.html

There are Different Types of SQL Joins which are used to query data from more than one tables. In this article, I would like to share how joins work in LINQ. LINQ has a JOIN query operator that provide SQL JOIN like behavior and syntax. Let's see how JOIN query operator works for joins. This article will explore the SQL Joins with C# LINQ.

1. INNER JOIN
2. LEFT OUTER JOIN
3. CROSS JOIN
4. GROUP JOIN

 

The JOIN query operator compares the specified properties/keys of two collections for equality by using the EQUALS keyword. By default, all joins queries written by the JOIN keyword are treated as equijoins.