The following query is not working in DB2 v 6 on OS/390 . How this can be achieved without creating a view. I would like to receive the min value from two tables.

SELECT MIN(VAL1) AS VAL2 FROM (
( SELECT MIN(COL1) AS VAL1
FROM TABLE1
)
UNION
( SELECT MIN(COL1) AS VAL1
FROM TABLE2
) )

Providing the error messages will be helpful

Cheers
Sathyaram

The error message is

SQL error at or before <EMPTY> (line 5, position 8). ) UNION

When I remove the parenthesis for inner selects it gives

SQL error at or before UNION

Hi,
You may try a SQL statment like this:

SELECT MIN(VAL1) AS VAL2 FROM
(
SELECT MIN(COL1) AS VAL1
FROM TABLE1
UNION
SELECT MIN(COL1) AS VAL1
FROM TABLE2
) as T1

Also, you can try next statement

SELECT CASE WHEN A < B THEN A ELSE B END
FROM (SELECT MIN(col1) A FROM table1) AS T1,
(SELECT MIN(col2) B FROM table2) AS T2

Saludos, Aloz

Hi Aloz

The query with case structure really works. That's Great !!