select t.subj_no || t.hc_no subj_no from RD t union all select d.subj_no || d.hc_no subj_no from SKY d order by subj_no