Hello,

There isn't really a hard limition. 
The only limitation that applies is the performance output of that aggregate.

Usually if you have an aggregate with a lot of joins it might indicate the database model is not designed in the most optimal way for queries.