SELECT deptcode         AS deptcode,
       subjcode         AS subjcode,
       nfundingneeds    AS nfundingneeds,
       localdebitamount AS localdebitamount,
       flossadj         AS flossadj,
       flossvalue       AS flossvalue,
       monthcashbgt     AS monthcashbgt,
       monthexe         AS monthexe,
       monthadj         AS monthadj,
       monthbgt         AS monthbgt
FROM   (SELECT *
        FROM   TEMQ_GXZYKMY
        UNION ALL
        SELECT *
        FROM   TEMQ_GXZYKME
        UNION ALL
        SELECT *
        FROM   TEMQ_GXZYKMS
        UNION ALL
        SELECT *
        FROM   TEMQ_GXZYKMSi
        UNION ALL
        SELECT *
        FROM   TEMQ_GXZYKMW ) AS un 
确保 TEMQ_XXX 这些表中的 列列类型一直，如果不一直转换成一直的。而且 每个 * 代表的字段数量都一样

------解决方案--------------------
没有问题，你执行报什么错？

------解决方案--------------------
探讨


DB2 SQL error: SQLCODE: -206, 
               SQLSTATE: 42703, 
               SQLERRMC: NFUNDINGNEEDS
SQL---就是刚才语句了


------解决方案--------------------
检查下表里面是否有NFUNDINGNEEDS这个字段，或则你是不是拼写错误了