(select sum(aa.qty) from "Finish01.DB" aa,
WHERE (aa.stockcode = 1)
AND (aa.Part = Prodlist.Partsno)
AND (Prodlist.Series = Series.Series)) as 期初数
WHERE (aa.stockcode = 1)
AND (aa.Part = Prodlist.Partsno)
AND (Prodlist.Series = Series.Series)) as 期初数
解决方案 »
- (delphi)如何返回update语句影响的行数,以及显示更新的数据。
- 再问短信后台程序怎么样让它开机就运行?
- 关于XMLHTTP的恶心问题!顶者有分!$$$$$$$$$$$$$$$$
- 请问无类型指针的修改应用
- 求教微软英语发音引擎-TTS的使用方法
- 学sql不久,对SQL不是很熟,求一SQL SERVER备份和恢复的源码,好急!
- 怎样显示报表页总数问题
- 我想用空格键和鼠标左键做同一件事,我怎样在按空格键后,调用OnMouseDown事件?
- 怎么来建立两个表的映射关系..第一次到宝地请大家多多指教??
- 如何在delphi 中修改ldap服务器中的结点属性
- Toolbar上面的toolbutton问题
- qunta(旺财1860) 。还是关于Drawgrid的问题。
FROM "Finish01.DB" Finish01, "series.DB" Series, "Prodlist.DB" Prodlist,"Finish01.DB" aa, "series.DB" bb, "Prodlist.DB" cc
WHERE (Finish01.Part = Prodlist.Partsno)
AND (Prodlist.Series = Series.Series) and (aa.stockcode = 1)
AND (aa.Part = cc.Partsno)
AND (cc.Series = bb.Series)
group by Series."Series-name"
WHERE (aa.stockcode = 1)
AND (aa.Part = cc.Partsno)
AND (cc.Series = bb.Series)) as 期初数 当成一个表进行处理,重新写SQL
有问题吧?好像前面select 中的不匹配
两位的方法我都试过了,都不行,其中windindance大哥的方法执行后"期初数"都一样,而hammer_shi大哥的方法得出的期初数是实际的好几百倍,打开QUERY的时候,我的PIII的机子停滞的足足一分钟.大家再帮忙看看吧.
AND (aa.Part = Prodlist.Partsno)
AND (Prodlist.Series = Series.Series)
AND (aa.Part = Prodlist.Partsno)
) as 期初数
行否
SELECT Series."Series-name" as 产品分类, avg(Prodlist.Uniteprice) as 期初单价,sum(aa.qty) as 期初数
(select from
WHERE (Finish01.stockcode = 1)
AND (Finish01.Part = Prodlist .Partsno)
AND (Prodlist .Series = Series.Series))
FROM "Finish01.DB" Finish01, "series.DB" Series, "Prodlist.DB" Prodlist
WHERE (Finish01.Part = Prodlist.Partsno)
AND (Prodlist.Series = Series.Series)
group by Series."Series-name"
要是你每个表里面的数据多于1万的话最好是建中间表,要不可能需要很长的时间。
至于分组,按理论就是在你Select 中的非分组查询条件都要用到,由于你只有Series."Series-name" 那么肯定可以。要不你就是有其他的select选项。SELECT Series."Series-name" as 产品分类, avg(Prodlist.Uniteprice) as 期初单价,sum(Finish01.qty) as 期初数
FROM "Finish01.DB" Finish01, "series.DB" Series, "Prodlist.DB" Prodlist
WHERE (Finish01.Part = Prodlist.Partsno)
AND (Prodlist.Series = Series.Series) and (Finish01.stockcode = 1)group by Series."Series-name"你把上面的语句拷贝运行看看是不是要的结果。否则我也没招。
SELECT Series."Series-name" as 产品分类, avg(Prodlist.Uniteprice) as 期初单价,
(select sum(aa.qty) as 期初数 from "Finish01.DB" aa, "series.DB" bb, "Prodlist.DB" cc
WHERE (aa.stockcode = 1)
AND (aa.Part = cc.Partsno)
AND (cc.Series = bb.Series))
FROM "Finish01.DB" Finish01, "series.DB" Series, "Prodlist.DB" Prodlist
WHERE (Finish01.Part = Prodlist.Partsno)
AND (Prodlist.Series = Series.Series)
group by Series."Series-name"