Master-Detail

Basic one-to-many report

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


Top Next