Using the contents of a filed for selection of the file

My question of today is, I know that in my library I have lots of files with
key field SSN in the text. I know from another thread that I can query the
QADBIFLD file and find all the files in that library that have "SSN" in the
text description.

I want to build a query that will do a select for each file found in
QADBIFLD and search for a SSN = 123456789, and do something with that. So
the field that contains the data for file name (dbifil) is what I want to
use. Something like;

With t1 as
(Select DBIFIL, DBIFLD
from QADBIFLD
where dbitxt like '%SSN%'
and DBILIB = 'MYLIBNAME')

Select * from (contents of dbifil) where (contents of dbifld) = 123456789

Is this do-able??

Jim