In some cases you can do things with a subquery that can't be done with join. However when using subqueries, there can be performance costs.