Hi
I already sent this already to the list, but I found another important
detail:
When I do the following query
select distinct recurso4_.id as id, decode (recurso4_.id, recurso4__1.id,
1,0 ) as clazz_
from
permissao permissa0_,
turma turma1_,
entidade turma1__1,
professor_turma professo2_,
professor professo3_,
recurso recurso4_,
agenda recurso4__1
where
turma1_.id=turma1__1.id and turma1_.id=professo2_.turma_id and
professo2_.professor_id=professo3_.id and
permissa0_.recurso_id=recurso4_.id and
recurso4_.id=recurso4__1.id(+) and
((permissa0_.entidade_id=turma1_.id)and(professo3_.usuario_id=1 )),
I got "Base table or view already exists;-6000 POS(1) Duplicate table
name.".
However, if I remove the "DISTINCT" clause, the "DECODE" clause, or remove
the outer join, the query executes correctly.
Thanks,
Robson Paniago
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
