Question

access sql 转 ms sql 遇到的问题！

SELECT id, (select sum(czmoney) from sh_chongzhi where id=1) AS sumcz, (sumcz-1) AS leftye FROM huiyuan where username='"&username&"'
提示列名 sumcz 无效
但这句话在ACCESS 时执行正常

Answer 1

sqlserver:
SELECT id, sumcz, (sumcz-1) AS leftye
FROM huiyuan,(select sum(czmoney) as sumcz from sh_chongzhi where id=1) a
where username='"&username&"'

Answer 2

你可以把as去掉试一下，并不是所有的数据库都支持as的

追问

数据库支持AS，去掉(sumcz-1)执行就正常！

追答

我明白了，这个sumcz字段是自定义的字段，不能在本基本的sql中使用，你可以在嵌套一层，比如：select id,sumcz,(sumcz-1) AS leftye from(
SELECT id, (select sum(czmoney) from sh_chongzhi where id=1) AS sumcz, FROM huiyuan where username='"&username&"')你试一下应该就可以了