"select 会员现等级,佣金比率 from customer f where f.客户编号 in (select f.*,e.总买入,e.总卖出,e.总额 from (" & _
"with x as(" & _
"select decode(b.客户编号,null,'999999',b.客户编号) as 客户编号,sum(a.成交价) as 总买入 from (auc_result a join auc_jtdj b on" & jieCiSelStr1 & " and a.竞投牌号=b.竞投牌号) join auctions c on" & jieCiSelStr1 & " where instr(upper(a.买家结算状况),'ZT')<1 group by b.客户编号)," & _
"y as(" & _
"select decode(b.委托方编号,null,'999999',b.委托方编号) as 委托方编号,sum(a.成交价) as 总卖出 from (auc_result a join contract b on" & jieCiSelStr1 & "and a.合同编号=b.合同编号) join auctions c on" & jieCiSelStr1 & " where instr(upper(a.买家结算状况),'ZT')<1 group by b.委托方编号)" & _
"select decode(x.客户编号,null,y.委托方编号,x.客户编号) as 客户编号,decode(x.总买入,null,0,x.总买入) as 总买入,decode(y.总卖出,null,0,y.总卖出) as 总卖出,decode(x.总买入,null,0,x.总买入)+decode(y.总卖出,null,0,y.总卖出) as 总额 from x full join y on x.客户编号=y.委托方编号) e left join customer f on e.客户编号=f.客户编号)"
"with x as(" & _
"select decode(b.客户编号,null,'999999',b.客户编号) as 客户编号,sum(a.成交价) as 总买入 from (auc_result a join auc_jtdj b on" & jieCiSelStr1 & " and a.竞投牌号=b.竞投牌号) join auctions c on" & jieCiSelStr1 & " where instr(upper(a.买家结算状况),'ZT')<1 group by b.客户编号)," & _
"y as(" & _
"select decode(b.委托方编号,null,'999999',b.委托方编号) as 委托方编号,sum(a.成交价) as 总卖出 from (auc_result a join contract b on" & jieCiSelStr1 & "and a.合同编号=b.合同编号) join auctions c on" & jieCiSelStr1 & " where instr(upper(a.买家结算状况),'ZT')<1 group by b.委托方编号)" & _
"select decode(x.客户编号,null,y.委托方编号,x.客户编号) as 客户编号,decode(x.总买入,null,0,x.总买入) as 总买入,decode(y.总卖出,null,0,y.总卖出) as 总卖出,decode(x.总买入,null,0,x.总买入)+decode(y.总卖出,null,0,y.总卖出) as 总额 from x full join y on x.客户编号=y.委托方编号) e left join customer f on e.客户编号=f.客户编号)"
谢谢阿