Connection between Print Job and Archive in IFS

SELECT *
FROM   archive_tab a, print_job_contents_tab pjc, print_job pj
WHERE  a.result_key     = pjc.result_key
AND    pjc.print_job_id = pj.print_job_id
AND    a.report_id      = '&YOUR_REP'
ORDER  BY a.result_key DESC;