What's new in Customer Journeys?

Connect and learn more!
ERROR:ORA-00918: column ambiguously defined — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ERROR:ORA-00918: column ambiguously defined

Received Response
17
Views
2
Comments

Summary:


SELECT **** , MARTIAL_STATUS , EMAIL_ADDRESS ,NATIONAL_IDENTIFIER_TYPE, NATIONAL_IDENTIFIER_NUMBER, LEGISLATION_CODE , CITIZENSHIP_STATUS

FROM

PER_ALL_ASSIGNMENTS_M F ,

PER_EMAIL_ADDRESSES pe,

per_people_legislative_f ppl,

per_national_identifiers PNI,

per_citizenships CZI

WHERE pe.person_id = f.person_id

AND ppl.person_id = f.person_id

AND PNI.person_id = f.person_id

AND CZI.person_id = f.person_id

AND MASTERED_IN_LDAP_FLAG = 'Y'

AND ROWNUM = 1


ERROR:ORA-00918: column ambiguously defined


Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!