Explain the difference between a join and a subquery, and describe a scenario where you would explicitly choose one over the other.
