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):