]]>三个月未½{‘Ö•http://www.aygfsteel.com/beijixuem/archive/2008/09/27/231529.html北æžé›?/dc:creator>北æžé›?/author>Sat, 27 Sep 2008 08:14:00 GMThttp://www.aygfsteel.com/beijixuem/archive/2008/09/27/231529.htmlhttp://www.aygfsteel.com/beijixuem/comments/231529.htmlhttp://www.aygfsteel.com/beijixuem/archive/2008/09/27/231529.html#Feedback0http://www.aygfsteel.com/beijixuem/comments/commentRss/231529.htmlhttp://www.aygfsteel.com/beijixuem/services/trackbacks/231529.html
select /*t5.emp_name as sale_name,
t9.emp_name as cs_name,
t5.dept_name,
t5.friend_id,
t5.friend_name,
t5.contract_number,
t5.total_value,
t5.so_id,
t5.start_date,
t5.end_date,
t5.friend_phone*/
count(*)
from (select t1.cust_id as friend_Id,
t1.so_id,
t1.emp_id,
t2.emp_name,
tf.friend_name,
t3.dept_name,
tf.friend_phone,
t1.so_code as contract_number,
t1.so_amount as TOTAL_VALUE,
t1.so_delivery_date as START_DATE,
t1.so_PAYMENT_DATE as END_DATE
from tc_sales_order_m t1,
tc_employee t2,
tc_department t3,
tc_friend tf
where t1.owner_id = 1
and t2.owner_id = 1
and t3.owner_id = 1
and tf.owner_id = 1
and t1.emp_id = t2.emp_id
and t2.dept_id = t3.dept_id
and tf.friend_id=t1.cust_id
and t1.cust_id in (select td.cust_id
from (select
tm.cust_id,
max(tm.so_payment_date) as end_date
from tc_sales_order_m tm
where tm.owner_id = 1
group by tm.cust_id) td
where td.end_date < add_months(sysdate, -3))
and t3.biz_dept_id = '110'
and t3.DEPT_CODE not like '0112%'
and t3.DEPT_CODE not like '0113%') t5,
(select t4.emp_name, t2.friend_id
from rel_friend_emp t2, tc_department t3, tc_employee t4
where t2.emp_id = t4.emp_id
and t3.dept_id = t4.dept_id
and t2.owner_id = 1
and t3.owner_id = 1
and t4.owner_id = 1
and t2.is_self = 1
and t3.biz_dept_id = '130') t9
where t5.friend_id = t9.friend_id(+)
]]>insert into select http://www.aygfsteel.com/beijixuem/archive/2008/08/29/insert.html北æžé›?/dc:creator>北æžé›?/author>Fri, 29 Aug 2008 02:52:00 GMThttp://www.aygfsteel.com/beijixuem/archive/2008/08/29/insert.htmlhttp://www.aygfsteel.com/beijixuem/comments/225505.htmlhttp://www.aygfsteel.com/beijixuem/archive/2008/08/29/insert.html#Feedback0http://www.aygfsteel.com/beijixuem/comments/commentRss/225505.htmlhttp://www.aygfsteel.com/beijixuem/services/trackbacks/225505.html阅读全文