摘要：
--从用户职别取 select sehd.person_id,sehd.last_name, fv.dept_id,sehd.dept_namefrom ( select papv.person_id, papv.last_name,ppdv.dept_name from (--用户表 select pap.person_id,pap.last_name from PER_ALL_PEOPLE_F pap where SYSDATE BETWEEN nvl(pap.EFFECTIVE_START_DATE,sysdate) AND nvl(pap.EFFECTIVE_END_DATE,sys. 阅读全文
posted @ 2012-01-06 10:52 奥客 阅读(369) 评论(0) 推荐(0) 编辑