H
handsome1234
Unregistered / Unconfirmed
GUEST, unregistred user!
这句error:试图执行的查询中不好含作为合计函数一部分的特定表达式a22
select input.a1 as a11,input.a2 as a22,input.a3 as a33
from input where input.a3 <'20020801' group by a1 //当我去掉
group by a1 时就正确了,
input表中只有a1,a2,a3,只有a2是数字型,其他均为字符型,
数据库为access
请大家解答解答
select input.a1 as a11,input.a2 as a22,input.a3 as a33
from input where input.a3 <'20020801' group by a1 //当我去掉
group by a1 时就正确了,
input表中只有a1,a2,a3,只有a2是数字型,其他均为字符型,
数据库为access
请大家解答解答