SQL Query to return ALL versions of every EPMDocument?

[btinder]

Hi all,

I've been trying to write a query which will return a list of every EPMDocument object and every revision of that in the database. I believe I need to hit EPMDocumentMaster and join that with EPMDocument, but I'm not sure how. Any help?

[BineshKumar1]

‌there should be a lot of reports in Resource for reporting‌

DB relationship - ida3masterreference of epmdocument = ida2a2 of epmdocumentmaster