hi,
Using the following Oracle version in both our DEV and QA databases.
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
I've got a problem where the query below generates ORA-00918: column ambiguously defined in dev, but not in QA.
select star.tpa.tpa_id
from star.plan
join star.tpa
on star.tpa.tpa_id = star.plan.tpa_id
join star.tpa
on star.tpa.tpa_id = star.plan.tpa_id
Is this something you could help me out with? Thanks!