I trying to create a view with the following SQL:
select
*
from
((agendasbusca
inner join usuarios on usuarios.codusuario = agendasbusca.codusuario)
inner join gruposusuario on gruposusuario.codgrupousuario =
usuarios.codgrupousuario)
left join buscas on agendasbusca.codagendabusca = buscas.codagendabusca
And I'm getting this error:
ERROR: CREATE TABLE: attribute "codagendabusca" duplicated
But I don't want to specify each field in the query, because I would
have to re-create the view on every change made on the source tables.
Is there any way to create the view in this way?
--
Diogo de Oliveira Biazus
diogo@ikono.com.br
Ikono Sistemas e Automação
http://www.ikono.com.br
