今天在问答频道一个朋友问的,我给他回答了,这里也做一个记录吧,他提供的表结构和数据如下:
我回复的sql语句如下:
select a.Sno,a.rtime,(case when ifnull(qty,0)-ifnull(cty,0)=0 then '完成' when ifnull(qty,0)-ifnull(cty,0)=ifnull(qty,0) then '待操作' else '进行中' end ) as zt,ifnull(qty,0),ifnull(cty,0) from (select Sno,SUM(cty) as qty,rtime from xx GROUP BY Sno,rtime) a LEFT join (select Sno,sum(qty) as cty from tt GROUP BY Sno) b ON a.Sno=b.Sno
执行效果如下: