clint_no(ncli) telno count 1 count 2 1 555 3 0 1 444 3 0 1 666 3 3 this is what i need to add to (mytable.count2) 2 555 6 0 . . . . . . . 6 this is what i need to add to (mytable.count2)
SELECT ncli, COUNT(ncli) AS telno FROM active ; GROUP BY 1 INTO CURSOR telno READWRITE INDEX ON ncli TAG ncli SELECT active SET RELATION to ncli INTO telno REPLACE ALL active.Count1 WITH telno.telnothanks.