ORA-00918 Coluna definida de maneira ambígua

Infraestrutura Banco de Dados
#1

Bom dia!

Tenho o seguinte select :

select mt.oid_meter, mt.description_meter, dr.id_analyze_rule, dr.id_meter, dr.date_active, nvl2(id_analyze_rule, ar.description, 'Todas as regras') description from rs_meter mt inner join disabled_rule dr on dr.id_meter = mt.oid_meter left join analyze_rule ar on dr.id_analyze_rule = ar.id_analyze_rule where mt.oid_meter = 1

esta retornando o erro ORA-00918 Coluna definida de maneira ambígua

Alguém sabe o que pode ser?

#2

Encontrei o erro rsrs… mas rapido do que imagina…

no trecho:

`select mt.oid_meter, mt.description_meter, dr.id_analyze_rule,
dr.id_meter, dr.date_active, nvl2(id_analyze_rule, ar.description, ‘Todas as regras’) description

faltou o alias da tabela na coluna id_analyze_rule

select mt.oid_meter, mt.description_meter, dr.id_analyze_rule,
dr.id_meter, dr.date_active, nvl2(dr.id_analyze_rule, ar.description, ‘Todas as regras’) description

resolvido!