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