2 error message
1.Feature is not supported for non-.DBC tables
i use free table
2.GROUP BY clause is invalid

>

>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 mucurtw
>

>
>From the top of my head - not tested.
>
>>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 (...)