Caterpillar Interview Question

when to use join in sql queries?