请问以下如何查询某种商品在所有销售单的销售情况?skxs.db 销售主表,skxsitem.db销售从表.
出错码是
invalid use of keyword
token:a.skxsid=b.skxsid
lie number;1.
**************************
var
asql:string;
begin
query2.close;
asql:='select a.xsdate as 销售日期,a.code as 销售编号,a.客户,b.shul as 数量,b.pmgk as 商品名称 ,b.sj as 单价 ,b.summ as 货款from skxs a,skxsitem b where a.skxsid=b.skxsid and b.pmgk=:pmgk';
query2.SQL.text:=asql;
query2.Params[0].AsString:='3kw';
query2.Open;end;
出错码是
invalid use of keyword
token:a.skxsid=b.skxsid
lie number;1.
**************************
var
asql:string;
begin
query2.close;
asql:='select a.xsdate as 销售日期,a.code as 销售编号,a.客户,b.shul as 数量,b.pmgk as 商品名称 ,b.sj as 单价 ,b.summ as 货款from skxs a,skxsitem b where a.skxsid=b.skxsid and b.pmgk=:pmgk';
query2.SQL.text:=asql;
query2.Params[0].AsString:='3kw';
query2.Open;end;
asql:='select a.xsdate as 销售日期,a.code as 销售编号,a.客户,b.shul as 数量,b.pmgk as 商品名称 ,b.sj as 单价 ,b.summ as 货款from skxs a,skxsitem b where a.skxsid=b.skxsid and b.pmgk=:pmgk';“货款”和“from”之间没有断开来!
还是在珠海好啊!
如何从销售主表中汇总出年度报表来?skxs.db 销售主表
销售日期 销售金额
2002-02-20 5000
2002-03-5 500
2003-01-2 50
2003-03-15 1000
2003-03-15 2000汇总成
年度 月份 销售金额
2002 2 5000
2002 3 500
2003 1 50
2003 3 3000
http://expert.csdn.net/Expert/topic/1535/1535056.xml?temp=.8047907
是呀太累了!
//=================================================
CREATE PROCEDURE usp_Sum
@year Char(4)
AS
IF EXISTS (SELECT name FROM sysobjects WHERE name = 'dtMainForm1_02' AND type= 'U')
DROP TABLE dtMainForm1_02
SELECT Year(DateData) AS 年度,Month(DateData) AS 月份, Sum(Price) AS 销售金额
INTO dtSum
FROM skxs
WHERE CONVERT(char(4),DateData,102)=@Year
GROUP BY Year(DateData),Month(DateData),Sum(Price)
GO
//========================================================
在程序中调用该存储过程时赋参数Year