When to use Subqueries versus joins?


On what scenario it is better to use JOINS over Sub queries?