Oracle Sql 求教——两表联合查询统计问题答:select custem, sum(isnull(money,0)) as money,sum(isnull(money1,0)) as money1,sum(isnull(money2,0)) as money2,sum(isnull(money3,0)) as money3 from (select B.custem, money case when state = 1 then money else 0 end money1,case when state = 2 then money else 0 ...