Use BREAK to eliminate redundant master data
break on id on name on sex skip 1
select name_id "id",
name_last||', '||name_first||' '||name_middle "name",
person_gender "sex",
student_reqseq "regseq",
student_sponsor "sponsof",
student_total_fee "fee
from student,
person,
name
where name_seriesno = name_now(name_id)
and name_id in ('133','226','505')
and person_id = name_id
and student_id = name_id
order by 1, 4;
id name sex regseq sponsor fee
----- ---------------------------------- --- ------ ---------- ------
133 O'Leary, Vincent M 1 Self 325
226 Sacco, Beth F 1 Mixed 1200
2 Self 200
3 Self 400
505 Carrington, Thomas M 1 Self 500
2 Employer 1500