34,590
社区成员
发帖
与我相关
我的任务
分享
select a.H1 sum(a.H2) as sumH2 from a left join b on b.H1=a.H1 where b.H3<sumH2
select * from(select a.H1 sum(a.H2) as sumH2 from a left join b on b.H1=a.H1) NewTAB where NewTAB.H3<NewTAB.sumH2
select a.H1,a.sumH2
from
(
select a.H1, sum(a.H2) as sumH2 from a group by a.H1
) a
left join b on b.H1=a.H1
where b.H3<sumH2