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.