OS390 および xOS 版
SELECT * F[[R]]OM FROM TABLE1 T1 INNE[[R]] INNER JOIN TABLE (
SELECT
F[[IE]]LD1, F[[IE]]LD2
F[[R]]OM FROM TABLE2 WHE[[R]]E WHERE FESGK03 = 'FOO' AND FESGK04 = 'BA[[R]]BAR'
GROUP BY F[[IE]]LD1, F[[IE]]LD2
) T2(F[[IE]]LD1, F[[IE]]LD2)
ON T1.F[[IE]]LD1 = T2.F[[IE]]LD1
AND T2.F[[IE]]LD1 = T2.F[[IE]]LD2