Hi Howard,

I can confirm the error 'SQL too complex' on view creation in VFP9 running your code.

>I don't do this too often - so didn't think I could create the code that easily. I do most of the work visually. Anyway, here is code that will work in VFP8 but not in VFP9.

>CLOSE TABLES all
>
>DELETE FILE test.dbc
>DELETE FILE table1.dbf
>DELETE FILE table2.dbf
>
>CREATE DATABASE test
>OPEN DATABASE test EXCLUSIVE
>
>CREATE TABLE table1 ;
>	(f1 c(10), ;
>	 f2 c(10), ;
> 	 f3 c(10), ;
> 	 f4 c(10), ;
> 	 f5 c(10), ;
> 	 f6 c(10), ;
> 	 f7 c(10), ;
> 	 f8 c(10), ;
> 	 f9 c(10), ;
> 	 f10 c(10), ;
> 	 f11 c(10), ;
> 	 f12 c(10), ;
> 	 f13 c(10), ;
> 	 f14 c(10), ;
> 	 f15 c(10))
> 	
>
>CREATE TABLE table2 ;
>	(f1 c(10), ;
>	 f2 c(10), ;
> 	 f3 c(10), ;
> 	 f4 c(10), ;
> 	 f5 c(10), ;
> 	 f6 c(10), ;
> 	 f7 c(10), ;
> 	 f8 c(10), ;
> 	 f9 c(10), ;
> 	 f10 c(10), ;
> 	 f11 c(10), ;
> 	 f12 c(10), ;
> 	 f13 c(10), ;
> 	 f14 c(10), ;
> 	 f15 c(10))
>
>SELECT table1
>
>FOR lnLoopCount = 1 TO 600000
>
>	APPEND BLANK
>
>NEXT
>
>GO TOP
>
>SELECT table2
>
>FOR lnLoopCount = 1 TO 600000
>
>	APPEND BLANK
>
>NEXT
>
>GO TOP
>
>MESSAGEBOX("Here goes...begin view creation")
>
>CREATE SQL VIEW v_test as ;
>	SELECT * ;
>	 FROM ;
>	     test!table1 ;
>	    INNER JOIN test!table2 ;
>	   ON  Table1.f1 = Table2.f1
> 	
>CLOSE TABLES all
>CLOSE DATABASES
>