Generate 9x9 using DB2UDB 8.2 SQL Statement


WITH N(X) AS (
SELECT 1 X
FROM SYSIBM.SYSDUMMY1
UNION ALL
SELECT N.X + 1
FROM N
WHERE N.X + 1 <= 9
)
SELECT N.X , N1.X , N.X * N1.X FROM N,N N1;