参考

 

select customername from (
    select p.projid, p.customername,p.assuremoney,l.pactmoney from proj_baseinfo  p 
    left join (select projid, sum(pactmoney)pactmoney from legal_pactset_info group by projid) l  on p.projid =l.projid 
) x where x.pactmoney >x.assuremoney;

select * from proj_baseinfo where projid in (
select projid from (
select tt.customername,pactmoney,assuremoney,tt.projid 
 from legal_pactset_info  tt left join proj_baseinfo pp on tt.projid=pp.projid
 ) group by projid  having sum(pactmoney)>sum(assuremoney)
 ) 

 

转载于:https://www.cnblogs.com/xh_Blog/p/11270887.html