ORA-00918: column ambiguously defined
Hello guys,
Please i need a help:
get this error ORA-00918: column ambiguously defined
When i try;
insert into OSD.OSD_CLIENTE_INSTALACAO
select
old.NUMERO_CLIENTE,
old.ANO,
11,
MES,
old.CODIGO_INSTALACAO,
old.CODIGO_PEE,
old.EMPRESA,
old.NOME,
old.ENDERECO,
old.POTN,
old.MEDIDOR,
old.SUBESTACAO,
old.CONSUMO,
old.CONJUNTO_ANEEL_PEE
from (select * from osd_cliente_instalacao
where ano = 2014 and mes =11 and empresa = 'BANDEIRANTE') new,
(select * from osd.osd_cliente_instalacao
where ano = 2014 and mes =10 and empresa = 'BANDEIRANTE') old
where old.numero_cliente = new.numero_cliente(+)
and new.numero_cliente is null;
Thanks