27,579
社区成员
发帖
与我相关
我的任务
分享
use database
select Fdate '日期',Fcheck as '审核',Fclose as '关闭',FBillNo as '订单号',
SUM(CAST(FBaseQty AS INT)) as '汇总数量',MAX(FSenddate) AS '最迟交货日期',
SUM(CAST(FstockQty AS INT)) as '汇总入库数量',
SUM(Fallamount) as '汇总金额',FEmpIDName as '业务员'
from vwICBill_26
where fdate >'2008-09-01'
GROUP BY FBillNo,Fdate,Fcheck,Fclose,FEmpIDName
having (SUM(CAST(FstockQty AS INT)) - SUM(CAST(FBaseQty AS INT))) < 0
ORDER BY '最迟交货日期' DESC
select * from
(
select Fdate '日期',
Fcheck as '审核',
Fclose as '关闭',
FBillNo as '订单号',
SUM(CAST(FBaseQty AS INT)) as '汇总数量',
MAX(FSenddate) AS '最迟交货日期',
SUM(CAST(FstockQty AS INT)) as '汇总入库数量',
SUM(Fallamount) as '汇总金额',
FEmpIDName as '业务员'
from vwICBill_26
where fdate >'2008-09-01'
GROUP BY FBillNo,Fdate,Fcheck,Fclose,FEmpIDName
) t where 汇总入库数量 - 汇总数量 < 0
ORDER BY '最迟交货日期' DESC