Question :
I am a newbie to the MySQL database.I want to know different types of joins in MySQL and any link or any other kind of documentation with examples which will clear the doubts will highly appreciable.
Answer :
Joins are a concept of Relational Algebra, you can find some information on wikipedia.
Join is considered an additional operator.