Fórum Erro ao criar um view (Invalid command ... SQL error code) #57837

CREATE VIEW VW_nivel1( graud, [color=red:fadbb5aa4d]--//grauc,[/color:fadbb5aa4d] [color=green:fadbb5aa4d]Sem este campo[/color:fadbb5aa4d] n_nivel, debito, credito, mes, ano) AS select tgrau1_d.graud, tgrau1_d.n_nivel, sum( tgrau1_d.valor ) as Debito, ( 0.0 ) as Credito, extract( month from tgrau1_d.datalcto) as mes, extract( month from tgrau1_d.datalcto) as ano from tgrau1_d inner join tgrau1_c on ( tgrau1_c.grauc = tgrau1_d.graud ) group by tgrau1_d.graud, tgrau1_d.n_nivel, tgrau1_d.datalcto UNION ALL select tgrau1_c.grauc, tgrau1_c.n_nivel, ( 0.0 ) as Debito, sum( tgrau1_c.valor ) as Credito, extract( month from tgrau1_c.datalcto) as mes, extract( month from tgrau1_c.datalcto) as ano from tgrau1_c inner join tgrau1_d on ( tgrau1_d.graud = tgrau1_c.grauc ) group by tgrau1_c.grauc, tgrau1_c.n_nivel, tgrau1_c.datalcto ;