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 (...)