PHOENIX-71 Support sub-joins