select isnull(sum(PAYMENT),0) RMB,C_CKSJ,K_XM,SALES.K_ID,
(这里该如写才能吧某个人(K_ID)未付的款子和求出来?(select ISNULL(sum(PAYMENT),0) from SALES where DONEPAYMENT=0 这样是所有人的欠款和求出来)REST
from SALES left join CLIENT on CLIENT.K_ID=SALES.K_ID
where DELYES=0 group by C_CKSJ,K_XM,SALES.K_ID order by C_CKSJ DESC
谢谢!
(这里该如写才能吧某个人(K_ID)未付的款子和求出来?(select ISNULL(sum(PAYMENT),0) from SALES where DONEPAYMENT=0 这样是所有人的欠款和求出来)REST
from SALES left join CLIENT on CLIENT.K_ID=SALES.K_ID
where DELYES=0 group by C_CKSJ,K_XM,SALES.K_ID order by C_CKSJ DESC
谢谢!
(select ISNULL(sum(PAYMENT),0) from SALES where DONEPAYMENT=0 AND K_ID = CLIENT.K_ID)REST
from SALES left join CLIENT on CLIENT.K_ID=SALES.K_ID
where DELYES=0
group by C_CKSJ,K_XM,SALES.K_ID order by C_CKSJ DESC
SID,产品编号,数量,出售价,总价,结算,出库时间,客户编号,卖掉部分,备注,退货标志,退货时间,操作人,删除标志、删除人
SID,SNUMBER,C_TXSL,C_CSJ,PAYMENT,DONEPAYMENT,C_CKSJ ,K_ID,C_PART,C_BZ,GOBACK1,C_THSJ,latedit,DELYES,DELGUY要求根据根据出库时间C_CSJ算出那一天客户(K_ID)总共多少货款PAYMENT,还没有付的总款子是多少(DONEPAYMENT=0 未付)