>Mark,
>
>From what I am seeing here, I not only have to paste the code, but change the clause order as well. Is the INNER JOIN ... ON structure the way to fix the code or is it trial and error to determine what works?
>
>TIA
>
>Rex
>

Yes, you also have to un-nest the JOINs. It is this nesting that causes the problem.

Many of us use the View Designer to get the initial field list, joins, filters, and order by. We then view the SQL to do a Copy and Paste into a PRG. All that is left is to un-nest the JOINs, add the Create SQL View MyView As prefix and some cosmetic work. I will then use either GENDBC or Erik Moore's eView utility to set the view parameters and make it updateable if necessary.