Query to fetch link between Revision Number and Document attached in that Revision

Hi all,

it is the first time i drop a question here, so apologize if i made some mistakes.

I need an help in order to write a query with cover this requirement:

We have a PO (or BPA), with more than 1 revision.

For each revision, i attach 1 document.

So, if i have a PO with 3 revision, i will have 3 document.

Revision 1 have document named "abc";

Revision 2 have document named "def"

Revision 3 have document named "ghi"

We need a query in order to be able to know that:

"abc" is inserted during Rev1

"def" is inserted during Rev2

"ghi" is inserted during Rev3