on 9/27/02 10:13 PM, Edwin Rose at ERose (at) LeapFrog .D.OT com wrote:
Hi Ed,
FIXED.
bug happens when we have few tables in JOIN,
and Min is on a field from not first table
in the FROM list.
> Hi Ruslan,
>
> The
>> SELECT AVG(STUDENT_ACTIVITY_STATUS.RAW_SCORE),
>> AVG(STUDENT_ACTIVITY_STATUS.AMT_TIME_TAKEN),
>> COUNT(STUDENT_ACTIVITY_STATUS.SAS_ID) with the below
> works fine but either of these with MIN or MAX gives the -39.
>
>
>> SELECT
>> MIN(STUDENT_ACTIVITY_STATUS.RAW_SCORE
>> FROM
>> LEAPPAD_ACTIVITY,
>> STUDENT_ACTIVITY_STATUS,
>> CLASSROOM_USER,
>> LEAPTRACK_USER
>> WHERE
>> (STUDENT_ACTIVITY_STATUS.CURRENT_COMPLETION_FLAG = 1)
>> AND (LEAPTRACK_USER.ARCHIVED_FLAG = 0)
>> AND (CLASSROOM_USER.CLASSROOM_ID = 1)
>> AND (LEAPPAD_ACTIVITY.ACTIVITY_CODE = 'SR21')
>> AND (STUDENT_ACTIVITY_STATUS.ID = CLASSROOM_USER.ID)
>> AND (STUDENT_ACTIVITY_STATUS.ID = LEAPTRACK_USER.ID)
>> AND (LEAPPAD_ACTIVITY.ACTIVITY_CODE =
>> STUDENT_ACTIVITY_STATUS.ACTIVITY_CODE)
--
Best regards,
Ruslan Zasukhin [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan@paradigmasoft.com
web: http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on (at) lists .D.OT macserve.net
-------------------------------------------------------------
©2002 Ruslan Zasukhin |
