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大侠们,帮忙看看这段SQL语句里面有什么问题?
(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大侠们,帮忙看看这段SQL语句里面有什么问题?
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 这些表中的 列列类型一直,如果不一直转换成一直的。而且 每个 * 代表的字段数量都一样
SQLSTATE: 42703,
SQLERRMC: NFUNDINGNEEDS
SQL---就是刚才语句了