The difference between an INNER JOIN, a RIGHT JOIN, and a LEFT JOIN.

Describe the difference between an INNER JOIN, a RIGHT JOIN, and a LEFT JOIN. Provide a business example where you would want to use each type of join.