[DB2][Database][SQL]
OS390 および xOS 版
SELECT * FROM TABLE1 T1
INNER JOIN TABLE (
SELECT
FIELD1, FIELD2
FROM TABLE2
WHERE FESGK03 = 'FOO'
AND FESGK04 = 'BAR'
GROUP BY FIELD1, FIELD2
) T2(FIELD1, FIELD2)
ON T1.FIELD1 = T2.FIELD1
AND T2.FIELD1 = T2.FIELD2
YAGI Hiroto (piroto@a-net.email.ne.jp)
twitter http://twitter.com/pppiroto
Copyright© 矢木 浩人 All Rights Reserved.