database - SQL Joining 4 Tables - Stack Overflow

You don't need to join subqueries back onto the tables that they are sourced from , and you can JOIN directly ...

stackoverflow.com