Need a SQL query to perform the requested task on three tables as identified below. Note we do not want to hard code the tables in our code.

Regarding the ZVSESTL2 tables, thanks. I was able to filter out the related tables needed for this project using this set. I've listed the real estate (RE) and license collector (LC) two tables, as well as the COBOL PROGRAM-ID column, below. This request aims to identify in each COBOL program the union or combination of the two tables RE and LC as well as their frequency in each program. Let me know if you have any questions. Thanks, see the image below and an example. The results from above example tables RE and LC are contained in program CVIABP0. \begin{tabular}{|l|l|l|} \hline Table - RE & Table LC & PROGRAM-ID \\ \hline & & \\ \hline NLXF & ARTN & CVIAAPO \\ \hline SADR & BDAT & CVLIABPO \\ \hline ADXF & CALC & CVLIACPO \\ \hline NGHD & CDAT & CVLIADPO \\ \hline CBLK & DTYP & CVLIBAPO \\ \hline ASMT & FISN & CVLIBCPD \\ \hline PRCL & GBLRATE & CVLIBCPO \\ \hline APPEAL & GBLYEAR & CVLIBDPO \\ \hline BLDGDR & LCPR & CVLIBEPO \\ \hline BLDGDT & LGAL & CVLIBGPO \\ \hline BLDGDN & TRAN & CVLIBHPD \\ \hline BLDGCB & TRDN & CVLIBHPG \\ \hline BLDCP & GBLRATE & CVLIBHPO \\ \hline BLDGCS & DTYP & CVLIBIPD \\ \hline RETRD1 & CDAT & CVLIBIPG \\ \hline RETRPM & CALC & CVLIBIPP \\ \hline RETRS1 & BDAT & CVLIBIPO \\ \hline RETRS2 & ARTN & \\ \hline RETRS3 & & \\ \hline RETRTR & & \\ \hline REAR & & \\ \hline \end{tabular} Regarding the ZVSESTL2 tables, thanks. I was able to filter out the related tables needed for this project using this set. I've listed the real estate (RE) and license collector (LC) two tables, as well as the COBOL PROGRAM-ID column, below. This request aims to identify in each COBOL program the union or combination of the two tables RE and LC as well as their frequency in each program. Let me know if you have any questions. Thanks, see the image below and an example. The results from above example tables RE and LC are contained in program CVIABP0. \begin{tabular}{|l|l|l|} \hline Table - RE & Table LC & PROGRAM-ID \\ \hline & & \\ \hline NLXF & ARTN & CVIAAPO \\ \hline SADR & BDAT & CVLIABPO \\ \hline ADXF & CALC & CVLIACPO \\ \hline NGHD & CDAT & CVLIADPO \\ \hline CBLK & DTYP & CVLIBAPO \\ \hline ASMT & FISN & CVLIBCPD \\ \hline PRCL & GBLRATE & CVLIBCPO \\ \hline APPEAL & GBLYEAR & CVLIBDPO \\ \hline BLDGDR & LCPR & CVLIBEPO \\ \hline BLDGDT & LGAL & CVLIBGPO \\ \hline BLDGDN & TRAN & CVLIBHPD \\ \hline BLDGCB & TRDN & CVLIBHPG \\ \hline BLDCP & GBLRATE & CVLIBHPO \\ \hline BLDGCS & DTYP & CVLIBIPD \\ \hline RETRD1 & CDAT & CVLIBIPG \\ \hline RETRPM & CALC & CVLIBIPP \\ \hline RETRS1 & BDAT & CVLIBIPO \\ \hline RETRS2 & ARTN & \\ \hline RETRS3 & & \\ \hline RETRTR & & \\ \hline REAR & & \\ \hline \end{tabular}