Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Column name "xxx" is already used in the SQL query error

Davor MaricJul 21 2017 — edited Jul 21 2017

Hi,

I have this query in report source

SELECT

TSJ.TSJ_ID,

TSJ.Vla_ID,

SO.Naziv,

TSJ.Sifra,

TSJ.Naziv,

TSJ.Br_Postelja

FROM Tipovi_SJ TSJ

JOIN Smjestajni_Objekti SO ON SO.SO_ID = TSJ.SO_ID

but on validation I get the error

Column name "NAZIV" is already used in the SQL query. Make sure that you use unique alias names for your columns.

Both tables have identically named column, but columns in query are properly aliased. The query runs OK from SQL Developer.

Using APEX 5.1.2 on OracleXE11.

How can I show two identically named DB columns in one report?

Thanks,

Davor

This post has been answered by Pranav.shah on Jul 21 2017

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 18 2017

Added on Jul 21 2017

#apex-discussions, #column, #query

2 comments

1,087 views