Hi,

how to solve? simple example:

RECREATE VIEW TMP_REGC100 AS
SELECT CODFOR
FROM TMP_NFENT
GROUP BY 1
UNION all
SELECT CODEMP
FROM TMP_NFSAI

-------------------
Dynamic SQL Error
SQL error code = -607
Invalid command
must specify column name for view select expression
-------------------

i tried no success:
.... AS SELECT * FROM ( SELECT ... GROUP ... UNION ... SELECT ... )