create cursor csrTypes (Type char(10) primary key) for lnI = 1 to 18 insert into csrTypes (Type) values (padl(lnI,10)) next select depno,empnam,empno, typ1,custno,; count(custno) As total_cfil,SUM(VAL(last)) As ntotal_cfil,SUM(VAL(now)) As ttotal_cfil,SUM(VAL(balance)) As rtotal_cfil ; from injaz1 In ; inner join csrTypes Ty on In.Typ1 = Ty.Type group By 1, 2,3,4,5 ; INTO table mucurtwFrom the top of my head - not tested.
>Select depno,empnam,empno, typ1,custno,; > count(custno) As total_cfil,SUM(VAL(last)) As ntotal_cfil,SUM(VAL(now)) As ttotal_cfil,SUM(VAL(balance)) As rtotal_cfil ; > from injaz1 ; > WHERE typ1 In (' 2',' 3',' 4',' 18') ; > group By 1, 2,3,4,5 ; > INTO table mucurtw > >>>>hi all,
>>>from injaz1 ; >>> WHERE typ1 In (' 2',' 3',' 4',' 18') ;&& i get many typ1 as 20 ,49...etc >>>>>>thanks