yzm664780(提问者)select a.*, b.SG_SIGN, b.ORDER_THICK, b.ORDER_LEN, b.FINISH_WT, b.NOT_WT
from (
select t.*
, NVL(r01.PLAN_WT, 0) PLAN_WT
from V_TSRSO03 t
left join isms.TSRSO01 r01
on r01.MONTH = t.PLAN_MONTH
and r01.SALE_DEPT = t.SALE_DEPT
and r01.PROTOCL_NO = t.PROTOCL_NO
and r01.REMARK_2 = t.PRODUCT_SALE_CLASSIFY
and r01.ORD_USER_NUM = t.ORDER_CUST_CODE
and r01.ORD_USER_NAME = t.ORDER_CUST_CNAME
) a
left join V_TSRSO03BILL b
on a.PLAN_MONTH = b.PLAN_MONTH
and a.SALE_DEPT = b.FACT_ORG
and a.PROTOCL_NO = b.PROTOCL_NO
and a.PRODUCT_SALE_CLASSIFY = b.PRODUCT_SALE_CLASSIFY
and a.ORDER_CUST_CODE = b.ORDER_CUST_CODE
and a.ORDER_CUST_CNAME = b.ORDER_CUST_CNAME
1min目标场景问卷
立即参与
