When you post code, you should use the "PRE" html tag so it doesn't reformat the code.

As far as why the joins now work, are you aware that with the first syntax, the ONs must be in the reverse order of the JOINs? I've never liked that syntax, and always use the syntax that specifies the ON right after the JOIN.

---

>I don't have it with me right now but here was the problem... I originally adapted the code from the "view sql"
>feature of the view designer. It was something like this....
>
>select...
> inner join
> inner join
> inner join
> inner join
> on
> on
> on
> on
>
>That worked till I had four aliases. So I changed it to...
>
>select...
> inner join on
> inner join on
> inner join on
> inner join on
>
>....and it works fine. Not smart enough yet to tell why.
>
>
>>>After I add a table back in a view for the fourth time I get an error that the first alias cannot be found. This is a hard coded
>>>view and not the view designer.
>>
>>Can you post the view code?