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