I have actually a expression instead of .t.

>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 ) )
>>