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]