Hey @doc1977! I suggest you have a look at this answer which suggests using Subquery for that.
Subquery