Query definition: column ambiguously defined

[Former Member]

When there are two columns with same name but with different table alias, i get this error.

For example, i have two columns in my query "Results Fields"  with T3.EXTERNAL_ID and T5.EXTERNAL_ID. This results in this error.

ORA-00918 column ambiguously defined.

If i remove one of them, everything is perfect. Even if I replace table alias with actual table name, it is same. I'm wondering if anyone has workarounds or experienced this issue before.

Thanks!

[Former Member · Accepted solution]

Hi Kranti,

Use the actual table name in the join instead of the alias. Hopefully that should resolve the issue.

Regards,

Parankush

[Former Member · Accepted solution]

Thanks for your response. It didn't help.

[Former Member · Accepted solution]

Hi Kranti,

Do you mind sharing the entire Query Definition ?

Regards,

Parankush