You could try something like this
-
SELECT field list
-
FROM YourTable
-
join ( SELECT TheMultipleResultField
-
FROM TheRecordSource
-
WHERE YourFilterRequirements
-
) a on column1=TheMultipleResultField
-
here, the join will filter out the rows that don't have matching
records in the subquery.