不太理解楼主sum('是或否')的目的
--trycreate or replace view v_bb_jxky3 as
select zgbm00,zcmch0,
sum(decode(sfjx00,'是',1,'否',0)) jxrs,
sum(decode(sfky00,'是',1,'否',0)) kyrs
from abc_dept00 b,abc_zc0000 c,abc_emp000 a
where a.zgbm00=b.bmmch0 and a.zgzch0=c.zcmch0
group by zgbm00,zcmch0
--trycreate or replace view v_bb_jxky3 as
select zgbm00,zcmch0,
sum(decode(sfjx00,'是',1,'否',0)) jxrs,
sum(decode(sfky00,'是',1,'否',0)) kyrs
from abc_dept00 b,abc_zc0000 c,abc_emp000 a
where a.zgbm00=b.bmmch0 and a.zgzch0=c.zcmch0
group by zgbm00,zcmch0
select
zgbm00,
zcmch0,
sum(decode(sfjx00,'是',1,'否',0) jxrs,
sum(sfky00) kyrs
from
abc_dept00 b,
abc_zc0000 c,
abc_emp000 a
where
a.zgbm00=b.bmmch0 and a.zgzch0=c.zcmch0
group by
zgbm00,zcmch0
马上结帐