CREATE CURSOR t1 ( rida c(10), month c(6) ) >CREATE CURSOR t2 ( rida c(10), month c(6) )>
DELETE FROM t1 ; > WHERE ( left(rida,2),month ) NOT IN ; > (SELECT left(rida,2), MAX(month) FROM t2 ; > group by 1) >>
DELETE T1; FROM t1 ; INNER JOIN (SELECT left(rida,2) AS Rida2,; MAX(month) AS Mnt FROM t2 ; group by 1) Tbl1; ON left(t1.rida,2) = Tbl1.Rida2 AND; t1.Month = Tbl1.Mnt