What is Join and what are the different types of Joins in SQL?

Question Explain

This question asks for the definition and varieties of SQL join operations. It tests practical querying skills.