56,687
社区成员
发帖
与我相关
我的任务
分享帮忙看下SQL语句，5.0可以执行，4.0.26版本就不行了
SELECT sum( je - htsk ) FROM (SELECT a.je, (SELECT sum( je ) FROM htje WHERE htbh = a.htbh AND deleted =0) AS htsk FROM htinfo a WHERE a.deleted =0 AND a.zt >=3 )t
...全文
请发表友善的回复…
发表回复
ACMAIN_CHM 2011-07-27
- 打赏
- 举报
4 还不支持子查询
karykwan 2011-07-26
- 打赏
- 举报
help
karykwan 2011-07-25
- 打赏
- 举报
首先谢谢rucypli，提示还有语法错误
rucypli 2011-07-25
- 打赏
- 举报
SELECT sum(a.je,-(SELECT sum( je ) FROM htje WHERE htbh = a.htbh AND deleted =0)) FROM htinfo a WHERE a.deleted =0 AND a.zt >=3