17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT b.cust_id, e.cust_id --e.cust_id
FROM (SELECT j.cust_id,
j.ORD_QTY,
j.ORD_AMT,
j.ord_id
FROM tb_aj002@erp_order j, tb_ag001@erp_order b
WHERE j.ord_stat_cd = '60'
AND j.good_id = b.good_id(+)
AND j.chg_cd IS NULL
AND j.gift_cd IS NULL
AND j.jjg_good_yn = 'N'
AND j.etr_date >=
TO_DATE ('2010-01-31', 'yyyy-MM-dd HH24:mi:ss')
AND j.etr_date <=
TO_DATE ('2010-02-01', 'yyyy-MM-dd HH24:mi:ss')
AND TO_CHAR (b.lclss_id) || TO_CHAR (b.mclss_id) IN
('112', '113', '114', '121', '122', '123', '111') --and j.cust_id='1002002'
) b,
cust_erp e
WHERE b.cust_id = e.CUST_ID
SELECT b.cust_id, e.cust_id --e.cust_id
FROM (SELECT j.cust_id,
j.ORD_QTY,
j.ORD_AMT,
j.ord_id
FROM tb_aj002 j, tb_ag001 b
WHERE j.ord_stat_cd = '60'
AND j.good_id = b.good_id(+)
AND j.chg_cd IS NULL
AND j.gift_cd IS NULL
AND j.jjg_good_yn = 'N'
AND j.etr_date >=
TO_DATE ('2010-01-31', 'yyyy-MM-dd HH24:mi:ss')
AND j.etr_date <=
TO_DATE ('2010-02-01', 'yyyy-MM-dd HH24:mi:ss')
AND TO_CHAR (b.lclss_id) || TO_CHAR (b.mclss_id) IN
('112', '113', '114', '121', '122', '123', '111') --and j.cust_id='1002002'
) b,
cust_erp e
WHERE b.cust_id = e.CUST_ID