Access的子查询的问题

[cloud1121]

select * from (select c.fkfs,sum(c.hjje) as hjje from jzxx1_ls c where c.jzsj>=#2002-3-5# and c.jzsj<=#2002-3-5# group by c.zdh,c.fkfs)
这个SQL语句老是报在FROM附近有错，但括号内的子查询是正确的，ACCESS的子查询是不是有什么特别的要求啊？

[warning]

就用select c.fkfs,sum(c.hjje) as hjje from jzxx1_ls c where c.jzsj>=#2002-3-5# and c.jzsj<=#2002-3-5# group by c.zdh,c.fkfs不就可以了，为什么还要 select * from？

[cloud1121]

这里只是举个例子，本来是还要再联接一个表做些计算的。

[warning]

试试这个
select * from (select c.fkfs,sum(c.hjje) as hjje from jzxx1_ls c where c.jzsj>=#2002-3-5# and c.jzsj<=#2002-3-5# group by c.zdh,c.fkfs) as a

[donotbesilent]

Access不支持From后面再用Select

[cloud1121]

to:爱就爱了，你的方法我开始就试过了，没用。
to:惊吧不已，Access可以在From后用Select，下面这句就可以用。
select sum(hjje) as hj from (select a.hjje from jzxx1_ls a,cdxx2_ls b where a.jzsj>=#" & m_time1 & "# and a.jzsj<=#" & m_time2 & "# and a.ysh=b.ysh group by a.zdh,a.hjje)

[LiaoCheng]

select * from (select c.fkfs,sum(c.hjje) as hjje from jzxx1_ls c where c.jzsj>=#2002-3-5# and c.jzsj<=#2002-3-5# group by c.zdh,c.fkfs)

好像你这个语句有两个from 这个试试：
select * from (select c.fkfs,sum(c.hjje) as hjje ，jzxx1_ls as c where c.jzsj>=#2002-3-5# and c.jzsj<=#2002-3-5# group by c.zdh,c.fkfs)

[cloud1121]

这样不行的

[cloud1121]

谢谢大家，原因找到了，是VB带的可视化数据管理器的问题，直接写在程序中是正确的。