Bug in Query Result

[Ruslan Zasukhin]

on 6/13/03 18:28, X Y at xyzabc1010 at yahoo.com wrote:

> Here are the steps to reproduce this:
> 1: The following Query returns the correct result:
> 
> SELECT  Session.student_id, Session.activity_id,
> Student.lname, Student.fname, Student.username,
> Session.session_id, PerformanceScore.value from
> Session, Activity, SessionDetail, Student,
> PerformanceScore where Session.student_id = 140
> 
> However, when I add more constraints I get a list of
> all the student. It seems like the query is not
> constraining Session.student_id = 140
> 
> SELECT  Session.student_id, Session.activity_id,
> Student.lname, Student.fname, Student.username,
> Session.session_id, PerformanceScore.value from
> Session, Activity, SessionDetail, Student,
> PerformanceScore where Session.student_id = 140 AND
> PerformanceScore.score_type = '3' AND
> Session.begin_date > '1/1/2003'

This is because in your last query you have NOT group
Session fields together.

Must be 

WHERE 
    Session.student_id = 140 AND
    Session.begin_date > '1/1/2003' AND
    PerformanceScore.score_type = '3'

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------