All types of joins and their features in SQL Server?

Question

I mean I want two study joins comprehensively so I must know about the similarities and differences of joins pleas guide me.

Joe Wilson · Answer

Thank you for your comprehensive answer it helped me a lot.

Pankaj Kumar Choudhary · Answer

Any body can not explain join here because it is a big Topic. So you can move to other resources like articles on joins. for this you can go here http://www.codeproject.com/Tips/712941/Types-of-Join-in-SQL-Server http://www.dotnet-tricks.com/Tutorial/sqlserver/W1aI140312-Different-Types-of-SQL-Joins.html http://stackoverflow.com/questions/17946221/sql-join-and-different-types-of-joins