Caterpillar interview question

when to use join in sql queries?