Problem with createview

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(at)ikono(dot)com(dot)br
Ikono Sistemas e Automação
http://www.ikono.com.br