question

What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN in SQL, and when would you use each?