34,590
社区成员
发帖
与我相关
我的任务
分享
select
sysj.ryid,syry.name1,
sum(case class1 when 1 then money1 else 0 end) as 一类,
sum(case class1 when 2 then money1 else 0 end) as 二类
from
sysj,syry
where
sysj.ryid=syry.id1
group by
sysj.ryid,syry.name1
select a.ryid,a.class1,b.name1,
sum(case a.class1 when 1 then money1 else 0 end) as 一类,
sum(case a.class1 when 2 then money1 else 0 end) as 二类
from
sysj a,syry b
where a.ryid=b.ryid
group by ryid
select
ryid,class1,name1,
sum(case class1 when 1 then money1 else 0 end) as 一类,
sum(case class1 when 2 then money1 else 0 end) as 二类
from
表
group by
ryid,class1,name1