sum() as not seperate column

[indu iyengar]

Hi

am trying to list the students whose creditPoints are < 50 by joining 2 tables.
Here am getting sum(creditPoints)<50 as seperate column ( as 0 for condition - notsatisfied rows, 1 for condition - satisfied rows )

Here I need to display the students who satisfy the condition.

 
SELECT studID,SUM(creditPoints)<50 AS totalCredits FROM studentenrollment JOIN courses ON studentenrollment.courseID=courses.courseID GROUP BY studID

is there any way to avoid seperate column and to display the condition satisfied rows only?

please help me , I strucked at this frm morning onwards any help would be highly appreciated
thanks
indu

[Jorn Hansen]

Hi Indu

Please consider trying a HAVING-clause:

 SELECT studID 
    FROM studentenrollment 
    JOIN courses 
       ON studentenrollment.courseID = courses.courseID 
 GROUP BY studID 
HAVING SUM(creditPoints)<50

/Jorn

[indu iyengar]

thaks Jorn it worked like a charm...

thanks
indu