Is seven inner joins in a query too much?

Question

I have a query that has 7 inner joins (because a lot of the information is distributed in other tables), a few coworkers have been surprised. I was wondering if they should be surprised or is having 7 inner joins normal?

Answer 1

it's not unheard of, but I would place it into a view for ease of use, and maintenance

Answer 2

Two questions:

1. Does it work?
2. Can you explain it?

If so, then seven is fine. If you can't explain the query, then seven is too many.