CREATE OR REPLACE VIEW "CG"."v_gjjzqje_tyzqxs" ("zqje", "zqxs", "kjqj") as select sum(nvl(a.zqbj),0) , c.tyzqxs , b.kjqj from q_ywlsb b,q_zqgjj_print a,v_zqxs c where a.ywlsh = b.ywlsh and b.isdelete is null and a.zqxs = c.zqxs group by b.kjqj,c.zqxs我的也报这个错
CREATE OR REPLACE VIEW "CG"."v_gjjzqje_tyzqxs" ("zqje", "zqxs", "kjqj") as select sum(nvl(a.zqbj,0)) , c.tyzqxs , b.kjqj from q_ywlsb b,q_zqgjj_print a,v_zqxs c where a.ywlsh = b.ywlsh and b.isdelete is null and a.zqxs = c.zqxs group by b.kjqj,c.zqxs
as
select
sum(nvl(a.zqbj),0) ,
c.tyzqxs ,
b.kjqj
from q_ywlsb b,q_zqgjj_print a,v_zqxs c
where a.ywlsh = b.ywlsh and
b.isdelete is null and
a.zqxs = c.zqxs
group by b.kjqj,c.zqxs我的也报这个错
as
select
sum(nvl(a.zqbj,0)) ,
c.tyzqxs ,
b.kjqj
from q_ywlsb b,q_zqgjj_print a,v_zqxs c
where a.ywlsh = b.ywlsh and
b.isdelete is null and
a.zqxs = c.zqxs
group by b.kjqj,c.zqxs