How does SQL JOIN clause works: Part –I (a little bit theoretical?)

A SQL JOIN clause is important issues in database operation. Actually one of my friend asked me – what are the different types of joining and how those joining are working. And what is the basic difference between them? Well in our daily life we are using different types of database like DB2, [...]