Clairvoyant Interview Question

Difference between different SQL joins.