For more information, please refer to this announcement explaining best practices for getting answers to questions.
ERROR:ORA-00918: column ambiguously defined
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):