摘要：
select per.party_id,per.person_id sales_resp_id,per.last_name sales_resp_name,per.full_name,fu.user_id from (--查询有效的用户 select per.party_id, per.person_id,per.last_name,per.full_name from PER_ALL_PEOPLE_F per where sysdate between per.effective_start_date and per.effective_end_date ) per, (--取有效的登... 阅读全文
posted @ 2012-02-29 13:23 奥客 阅读(237) 评论(0) 推荐(0) 编辑