Your where clause always evaluates to .t.. You can just remove it.

select * ;
   from toode ;
      left OUTER JOIN artliik ;
        ON .f.

Yes, VFP Sql Select is limited. You've to live with it or switch to Sql Server or whatever. You can also request it enhancement in the future versions of VFP.


>The following simple code produces error
>
>SQL expression is to complex (VFP7 SP 1)
>
>Help says: Visual FoxPro ran out of memory ....
>
>I have 256 MB RAM. Why vfp is not capable to run this simple select ?
>
>

>
>CREATE CURSOR alloweditems ( liik c(10))
>CREATE CURSOR artliik ( liik c(1))
>CREATE CURSOR toode ( f1 c(1))
>SYS(3055,2040)
>select * ;
>   from toode ;
>      left OUTER JOIN artliik ;
>        ON .f. ;
>   where .t. OR ;
>  (.f. AND artliik.liik in (select * from alloweditems ) )
>