------------------------------ Commands Entered ------------------------------
connect to SAMPLE ;
------------------------------------------------------------------------------

   Database Connection Information

 Database server        = DB2/NT 9.5.2
 SQL authorization ID   = DB2ADMIN
 Local database alias   = SAMPLE


A JDBC connection to the target has succeeded.
------------------------------ Commands Entered ------------------------------
WITH
 X(d) AS (VALUES
1, 2, 5
)
,Y(e) AS (VALUES
1, 3, 4, 5
)
,M(b, c) AS (VALUES
 (1, 'aaa')
,(2, 'bbb')
,(3, 'ccc')
)
SELECT a, M.c
FROM 
(SELECT d AS a
FROM X
UNION ALL
SELECT e AS a
FROM Y) Z, M
WHERE Z.a = M.b
;
------------------------------------------------------------------------------

A           C  
----------- ---
          1 aaa
          3 ccc
          1 aaa
          2 bbb

  4 record(s) selected.

with t1 (a) as (SELECT d AS a
FROM X
UNION ALL
SELECT e AS a
FROM Y) select t.a,m.c from t1 as t inner join m as m on (t.a = m.b)