SQL to join two queries

SQL sages, (me not)

I’m trying to get a list of journaled objects with object text into a result set.

I can get the list of objects easily:

SELECT OBJECT_LIBRARY FROM QSYS2.JOURNALED_OBJECTS
WHERE JOURNAL_LIBRARY = '#MXJRN' AND
JOURNAL_NAME = 'MISC'
ORDER BY OBJECT_LIBRARY;

I can get the text for each of the objects equally easily.

SELECT OBJNAME, OBJTEXT FROM TABLE (QSYS2.OBJECT_STATISTICS('#MXJRN', '*ALL'));

What I’m having a devel of a time doing is getting the query to show object name, object text.

I know this can be done with a select inside another select, but I’ll be danged I can’t get the code right.
What is the solution?

Jim Oberholtzer
Agile Technology Architects