SELECT

'Q+2' 季度,

A5.fd_no 销售负责人编号,

A5.fd_name 销售负责人姓名,

SUM(nvl(A1.fd_quantity, 0)) 销售数量,

SUM(nvl(A1.fd_order_money, 0)) 销售金额,

SUM(nvl(A4.xxxx, 0)) xxxx,    --  -- xxxx字段

    SUM(nvl(A4.yyyy, 0)) yyyy         --  -- yyyy字段

FROM

nxw_order_detail A1

LEFT JOIN nxw_order_main A2 ON A1.doc_main_id = A2.fd_id

LEFT JOIN nxw_crm_customer A3 ON A2.fd_customer_id = A3.fd_id

LEFT JOIN (

SELECT

FD_order_NUMBER,

SUM(nvl(fd_quantity, 0)) 已交数量,

SUM(nvl(fd_current_tax_before, 0)) 已交金额

FROM

nxw_ship_main

GROUP BY

FD_order_NUMBER

) A4 ON A4.FD_order_NUMBER = A2.FD_NUMBER

LEFT JOIN sys_org_element A5 ON A3.fd_sales_id = A5.FD_ID

LEFT JOIN sys_org_element A6 ON A5.fd_parentid = A6.FD_ID

WHERE

to_char (A1.fd_damand_date, 'yyyy-q') = to_char (

add_months (sysdate ,+ 6),

'yyyy-q'

)

GROUP BY

A5.fd_no,

A5.fd_name,

'Q+2'

——————————————————————————