SELECT to_char(jre.resource_id) , ppf.full_name , jre.START_DATE_ACTIVE , jre.CATEGORY FROM jtf_rs_resource_extns jre, per_people_f ppf WHERE ppf.person_id = jre.source_id order by 2
View Text - HTML Formatted
SELECT TO_CHAR(JRE.RESOURCE_ID) , PPF.FULL_NAME , JRE.START_DATE_ACTIVE , JRE.CATEGORY FROM JTF_RS_RESOURCE_EXTNS JRE , PER_PEOPLE_F PPF WHERE PPF.PERSON_ID = JRE.SOURCE_ID ORDER BY 2