Join on parent vs subquery