select dt.type, di.name from DEGREE_DEGREE_INFO ddi inner join DEGREE_INFO di on ddi.OID_DEGREE_INFO = di.OID inner join DEGREE d on ddi.OID_DEGREE = d.OID inner join DEGREE_TYPE dt on dt.OID = d.OID_DEGREE_TYPE order by 1,2;