在access中,查询的对象相关性,在引用对象里说:缺少:SELECT FROM data a, (SELECT max(rq) AS max_rq, gsdm FROM data GROUP BY gsdm) b
兄弟刚学不懂,盼望大家帮忙解决。
这是设计视图里的代码:
SELECT c.gsdm, c.gsmc, c.bcjsl-d.bcjsl AS mrlc, c.scjsl-d.scjsl AS mclc
FROM [SELECT a.*
FROM data a, (SELECT max(rq) AS max_rq, gsdm FROM data GROUP BY gsdm) b
WHERE a.rq=b.max_rq and a.gsdm=b.gsdm]. AS c, [SELECT a.*
FROM data a, (SELECT min(rq) AS min_rq, gsdm FROM data GROUP BY gsdm) b
WHERE a.rq=b.min_rq and a.gsdm=b.gsdm]. AS d
WHERE c.gsdm=d.gsdm;
我有一个软件,读2004的数据好使,用2005的数据就读不出来,不知是怎么回事,在注册上没限制,即使把2004的数据日期改成2005也读不出来,请帮忙