What is a SQL JOIN, and what are the different types?

Edit
Report