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