使用 null MS Access 进行计算

发布于 2024-10-30 23:36:53 字数 396 浏览 0 评论 0原文

我的表名称是 MS ACess 中的 CAPCON 字段ae ID,Transaction, AMount，

我的查询是

Select distinct( CapCon.ID),
 (Select sum(amount) from CapCon as c 
    where c.id=CapCon.id 
    and transaction='Deposite') - 
 (Select sum(amount) from CapCon as c 
    where c.id=CapCon.id and transaction='Withdrawal') 
as [Capital Contribution] from CapCOn

如果没有提现交易，则对应ID的【出资】中没有输出

原文

My Table name is CAPCON in MS ACess
Fields ae ID,Transaction, AMount,

My query is

Select distinct( CapCon.ID),
 (Select sum(amount) from CapCon as c 
    where c.id=CapCon.id 
    and transaction='Deposite') - 
 (Select sum(amount) from CapCon as c 
    where c.id=CapCon.id and transaction='Withdrawal') 
as [Capital Contribution] from CapCOn

IF the there is no withdrawal transaction, there is no output in [Capital Contribution] for the corresponding ID

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

差↓一点笑了 2024-11-06 23:36:53

您需要检查 where 子句中是否为 null：

Select distinct( CapCon.ID),
  (Select sum(amount) from CapCon as c 
     where c.id=CapCon.id 
     and transaction='Deposite') -
  (Select sum(amount) from CapCon as c 
     where c.id=CapCon.id 
     and transaction='Withdrawal' 
     and transaction is not null) 
as [Capital Contribution] from CapCOn

You need to check for null in your where clause:

Select distinct( CapCon.ID),
  (Select sum(amount) from CapCon as c 
     where c.id=CapCon.id 
     and transaction='Deposite') -
  (Select sum(amount) from CapCon as c 
     where c.id=CapCon.id 
     and transaction='Withdrawal' 
     and transaction is not null) 
as [Capital Contribution] from CapCOn

回复收藏 0 原文

~没有更多了~