On 10/26/2011 9:34 AM, eric_developer wrote:

>
> 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 ... )
>
>
>
>

What version of FB? And what type is CODFOR and CODEMP? I ran it in FB
2.5.1 on two tables with an integer ID field and it works.

--
Thanks,

Gordon



[Non-text portions of this message have been removed]