10 or more joins are not a problem.

Bad normalized/designed data structure and no properly indexed tables are.

Just try to outer join two big tables by no indexed columns or using implicit data type conversion and you ill fell the pain.

(inner) joining 10 huge (well designed) tables by (tunned) indexed columns ill run smoothly.