I'll suppose you are doing a join between a table having location (table LOC, column LOCATION) with another having person names (table PERSON, column NAME). You must have a column linking these tables (let's call DEPT_ID). Try the query:

select A.LOCATION, B.NAME
from LOC A, PERSON B
where A.DEPT_ID=B.DEPT_ID
and B.DEPT_ID in
(select distinct DEPT_ID from LOC where rownum<=3)
;



Adriano.