What are SQL joins and how do INNER, LEFT, RIGHT, and FULL differ?

Question Explain

This is a core question evaluating mastery of combining data from multiple tables effectively.