关于两个表sql语句的问题

悬赏园豆：20 [已解决问题] 解决于 2018-11-07 16:15

表1：Projects
字段：ID，ContractMoney（合同金额）

表2：Finances
字段Porject_ID,ReceivedMoney(回款金额)

(一对多的关系)

要求:筛选出没有全部回款的项目和
筛选出全部回款的项目

一共两个sql语句

Melody.Gkx | 初学一级 | 园豆：196
提问于：2018-11-06 14:58

< >

最佳答案

select * from Projects p left join (select Porject_ID sum(ReceivedMoney)ReceivedMoney from Finances group by Porject_ID) f on p.ID=f.Porject_ID
where ContractMoney>isnull(ReceivedMoney ,0)

2.select * from Projects p left join (select Porject_ID sum(ReceivedMoney)ReceivedMoney from Finances group by Porject_ID) f on p.ID=f.Porject_ID
where ContractMoney<=isnull(ReceivedMoney ,0)

收获园豆：20

fangq | 菜鸟二级 |园豆：417 | 2018-11-06 15:28

其他回答(2)

百度搜索一下子查询，可以解决

会长 | 园豆：12463 (专家六级) | 2018-11-06 15:06

2.select * from Projects p left join (select Porject_ID sum(ReceivedMoney)ReceivedMoney from Finances group by Porject_ID) f on p.ID=f.Porject_ID
where ContractMoney<=isnull(ReceivedMoney ,0)

xxy12 | 园豆：124 (初学一级) | 2018-11-06 15:35

清除回答草稿

您需要登录以后才能回答，未注册用户请先注册。

欢迎，请先 登录 或者 注册 。

关于两个表sql语句的问题

欢迎，请先登录或者注册。