>I have tables
>
>

CREATE CURSOR t1 ( rida c(10), month c(6) )
>CREATE CURSOR t2 ( rida c(10), month c(6) )

>
>I need to delete from table t1 so that only last month rows remain.
>
>I tried
>
>

DELETE FROM t1 ;
>  WHERE ( left(rida,2),month ) NOT IN ;
>   (SELECT left(rida,2), MAX(month) FROM  t2 ;
>   group by 1)
>

>
>but got error
>
>Function name is missing )
>
>
>How to run this statement in VFP ?

Try :

DELETE FROM t1 ;
  WHERE left(rida,2) NOT IN ;
   (SELECT left(rida,2) FROM  t2 where month in (sele MAX(month) FROM t2))