主题：sql group by咨询

Select a.[合同编号],a.[序号],b.[jel],b[sl]  FROM {明细表a} As a left join (Select [合同编号],[序号],SUM(金额) as jel,SUM(数量) as sl from {明细表b} group by 合同编号 ,序号) As b  on (a.[合同编号]=b.[合同编号] and a.[序号]=b.[序号]) 

Tables("提佣支付_Table1").Fill("S elec t a.[合同编号],c.[客户名称],a.[申请笔数],a.[申请金额],b.[已支付额],c.[经手人]  F ROM {租赁合同佣金提取明细表} As a left join (selec t 合同编号,客户名称,经手人 f rom {租赁合同佣金提取情况表}) as c on (a.[合同编号]=c.[合同编号]) l eft join (S elec t [合同编号],[申请笔数],IIF(sum(本次支付金额) is null,0,sum(本次支付金额)) as 已支付额 from {租赁合同提佣发放明细表} g roup by 合同编号,申请笔数) As b on (a.[合同编号]=b.[合同编号] and a.[申请笔数]=b.[申请笔数]) w here (b.[已支付额] is null or a.[申请金额] > b.[已支付额]) ","cs2",True)