>Change the INNER JOINS to WHERE clauses. For whatever reason, the query engine takes longer to process joins than it takes to process the same results from a where statement.
>
>Just a thought.
>
>>This view is currently taking about 2.5 minutes to load.
>>Can anyone help me speed up this select/view?
>
>*snip*

I already tried that and it came out about the same.