更容易限制SELECT子查询中的行？

I perform queries on an Oracle database. Let's say I have a table, PEOPLE. Each person can have multiple reference numbers. The reference numbers are stored in a different table, REFERENCENUMBERS.I perform queries on an Oracle database. Let's