>Try :
>

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

This does not work.

sele MAX(month) FROM t2

returns global maximum only.
I need different maximums for each left(rida,2) groups.