Performance Implications when Views JOIN added twice?
Astonish Design did a good write up on this topic: Writing Efficient Queries in Drupal.

You should measure your specific queries though, it always depends on the amount of data you are working with, proper indices, mysql configuration and so on. Joining too many tables will almost always increase your query execution time, keep that in mind.