الاستعلام الفرعي عن صف أعاد أكثر من صف ORA-01427

 select distinct  emp.EMPLOYEE_NUMBER,emp.FULL_NAME,NATIONAL_IDENTIFIER,Decode

,(sex, 'M', 'ذكر', 'انثى') sex

                  EMAIL_ADDRESS,ass.ASSIGNMENT_STATUS_TYPE_ID ASS_STATUS,PHONE_NUMBER



From PER_ALL_PEOPLE_F emp, PER_ALL_ASSIGNMENTS_F ass,PER_PHONES ph



Where PHONE_NUMBER = (select PHONE_NUMBER from PER_PHONES ph where ph.PARTY_ID = emp.PARTY_ID )

         And emp.PERSON_ID = ass.PERSON_ID

         And SYSDATE BETWEEN emp.EFFECTIVE_START_DATE AND emp.EFFECTIVE_END_DATE

         And SYSDATE BETWEEN ass.EFFECTIVE_START_DATE AND ass.EFFECTIVE_END_DATE

 



order by 1

 

الاستعلام ده

(select PHONE_NUMBER from PER_PHONES ph where ph.PARTY_ID = emp.PARTY_ID )

رجع باكتر من صف .

 

- استخدم in operator , واتأكد من ربط الجداول .