Prototyping is helpful, you can try out a single join in various ways and compare what you’re reasonably able to execute.