oracle 如何将将A4中的两个字段加入到省略号的地方。一直获取不到。SELECT 'Q+2' 季度, A5.fd_no 销售负责人编号, A5.fd_name 销售负责人姓名, SUM(nvl(A1.fd_quantity,0)) 销售数量, SUM(nvl(A1.fd_order_money,0)) 销售金额, A4.FD_order_NUMBER 已交数量, ............ 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'