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.
This is the query:
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
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
