>>i want to group by Student.family(in ENGINEBEHAVIOR 70 no problem) but how this will work in 90. i try, but not work.
>>

SELECT Student.id, Student.name, Student.family, Student.ptcl,;
>>  Student.cv, Smssha.shdate, Smssha.inshu;
>> FROM ;
>>     student,;
>>    smssha;
>> WHERE  ( admtd ) = ( 1 );
>> GROUP BY Student.family, Student.name, Student.id, Student.ptcl,;
>>  Student.cv, Smssha.shdate, Smssha.inshu;
>> INTO CURSOR mo333

>
>Did you get an error or wrong result? The code seems to be syntactically correct.
i have no error but wrong results. I have 800 records in this table but when i group by student.family, it should be 400 records in cursor.