You’re right. I’m trying to set one up right now and that’s exactly what’s happening. If you do it the way you showed, it’s like it’s its own little subquery for each row. That’s awesome, I had no idea you could do this.
So after setting it up, your sub query can only return one column or it pukes, good to know, but it does a good job at the one piece of info.