Search Result of First name:"David", Last name:"Conover" & Status: "Faculty"
select e.first_name||' '||e.middle_name||' '||e.last_name,e.type_person,e.mailname, e.mailbox, e.major, e.class, e.department, e.building, e.room, e.zip, e.phone from acc.person p, acc.epo e where e.person_id = p.id and p.employment_status in ('A','L') and p.type not IN ('03','04') and p.last_name like 'CONOVER%' and p.first_name like 'DAVID%' and e.type_person = '01' and e.withhold_all is NULL and e.not_standard is NULL and rownum < 21 order by e.last_name,e.first_name,e.middle_name
No match found