select 1.f1,2.f2.3.f3
from t as 1,y as 2,u as 3
where 1.t=2.t
order by 1.f1,2.f2
这段是可以执行的,但是后面加上
compute by sum(3.f3)就提示:
(语法错误,操作符丢失,在查询表达式compute by sum(3.f3)中 )
为何?我用的是access谢谢!
...全文
454打赏收藏
compute by 的使用。。。
select 1.f1,2.f2.3.f3 from t as 1,y as 2,u as 3 where 1.t=2.t order by 1.f1,2.f2 这段是可以执行的,但是后面加上 compute by sum(3.f3)就提示: (语法错误,操作符丢失,在查询表达式compute by sum(3.f3)中 ) 为何?我用的是access谢谢!