Can you explain the difference between a join and a subquery, and when you would use one over the other?
