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 (select type from legalvalue); group By 1, 2,3,4,5 ; INTO table mucurtw>thank you fro reply,
>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