Left Join an Aggregated Query

I am executing a 'Query All Records' based on a userID. I am then aggregating those records with Count Distinct, and a Sum aggregation.

I want to subsequently (within the same function, or separate) left join another table where the PointFloor variable < = TotalPoints AND PointCeling > TotalPoints.

Is there any way to do this? I know you can join tables in the Filter By Joins section. But that only looks to work if you are joining pre-aggregation (unless I am missing something).