Howard,

It would be easier to verify it if you provide repro code.

>I'd like someone to verify that they get the message "SQL too complex" upon completing these steps. It only occurs in VFP9 - VFP8 works fine (on my system.)
>
>1. Create two tables (table1 and table2) with 15 fields (f1, f2...f15) each. Each field should be a C(10) field. No indexes needed to reproduce.
>2. Create a DBC and add the two tables to the DBC
>3. Add 600000 blank records to each table
>3. Create a local view on the two tables with an inner join on the first field (f1)
>4. Select "*" or All fields in the View Designer
>5. Close the View Designer
>
>After naming the view, you should get the 'SQL too complex' message.
>
>If you select all fields from table1 and the first 12 fields from table2, the view will work.
>
>If you delete 50000 recs from table1, the view will work with all fields selected.
>
>I need to be sure this is not something unique to me - anyone who could try to reproduce would be helpful - thanks.