i2c interview question

What are joins? Inner join, outer join. Explain all.