Create a separate table with all the "legal" values in it.

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,
>??this is the code i need your help to create a cursor with every type as a record and JOIN with that cursor
>
>

>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,
>>>
>>>i need to select as ==2 , == 3 ...4, and ==18...etc
>>>

>>>from injaz1 ;
>>>  WHERE typ1 In ('          2','          3','          4','          18') ;&& i get many typ1 as 20 ,49...etc
>>>

>>>thanks
>>
>>I suggest to create a cursor with every type as a record and JOIN with that cursor. It should be better than Type IN (...)