kcl是计算字段var
e:double;
begin if not goodsqy.fields[0].isnull then
begin
squ.Close;
squ.SQL.clear;
squ.SQL.Add('select sum(onhand)from onhand where goodsid=:goodsid group by goodsid');
squ.params[0].asstring:=goodsqy['goodsid'];
squ.prepare;
squ.Open;
e:=squ.Fields[0].asfloat;
goodsqy['kcl']:=e;
end;
e:double;
begin if not goodsqy.fields[0].isnull then
begin
squ.Close;
squ.SQL.clear;
squ.SQL.Add('select sum(onhand)from onhand where goodsid=:goodsid group by goodsid');
squ.params[0].asstring:=goodsqy['goodsid'];
squ.prepare;
squ.Open;
e:=squ.Fields[0].asfloat;
goodsqy['kcl']:=e;
end;
from xxx, onhand, ...
inner join xxx.goodsid = onhand.goodsid
group by goodsid
你又出现了,太可怕了。
不知怎么称呼?请别见怪。在此先谢了!
我原来执行是select * from goods ,库存量从别的表中得到。
你的意义是这样
select a.* form goods a inner join select sum(b.onhand) from onhand b group by b.goodsid on a.goodsid=b.goodsid
你又出现了,太可怕了。
不知怎么称呼?请别见怪。在此先谢了!
我原来执行是select * from goods ,库存量从别的表中得到。
你的意义是这样
select a.* form goods a inner join select sum(b.onhand) from onhand b group by b.goodsid on a.goodsid=b.goodsid