I have a field in a table, ACT_OVGPA that represents a student's current overall gpa. The field is a 2 digit number on a scale of 00-40 where I believe there is an implied decimal point and actually represents 0.0 - 4.0.
This is what I have written, but it returns an error "too many values". Can you help me get the right data? Thank you
set act_ovgpa = (select round(shrlgpa_gpa),1 from shrlgpa
where shrlgpa.shrlgpa_type_ind = 'O'
and shrlgpa.shrlgpa_pidm = jwcc_act.act_pidm)
(select shrlgpa_gpa from shrlgpa
where shrlgpa_pidm = jwcc_act.act_pidm);