Duplicate table name

Hi,

Can any one please tell me a workaround for this issue.....

> SAPDB version: 7.4.3.17

I�m new in Sapdb and also in SQL.My problem is, when I execute this query first time I get the good result, but the second time I get this error:

Base table or view already exists;-6000 POS(1) Duplicate table name.

select t.nombre, sum(tabla_importes.importe) as impor, t.tecnologia_id_pk

from tecnologias t left join

(select co.tech_id_fk, co.importe, cl.razon_social, co.mes, co.ano

from clientes cl, consumos co, empresas_grupo_ttt e

where co.cliente_id_fk = cl.cliente_id_pk

and e.empresa_id_pk = 1

and co.mes =1

and co.ano = 2000

and cl.cliente_id_pk = 1

) tabla_importes

on t.tecnologia_id_pk = tabla_importes.tech_id_fk

where tecnologia_id_pk IN(

Select tecno.tecnologia_id_pk

from tecnologias tecno, consumos c, empresas_grupo_ttt egt

where tecno.tecnologia_id_pk = c.tech_id_fk

and c.empresa_id_fk = egt.empresa_id_pk

)

group by t.nombre, t.tecnologia_id_pk

order by t.nombre,

What is the problem?, thank you

Reply via email to