本帖最后由 夏日秋语 于 2011-4-19 22:50 编辑
SELECT TOP (100) PERCENT dbo.Pub_Etype.FullName AS 业务员, dbo.SCM_BillDetail_SaleBill.BillCode AS 单据编号,
dbo.SCM_BillDetail_SaleBill.BillDate AS 日期, dbo.Pub_Btype.FullName AS 往来单位, dbo.Pub_Ptype.FullName AS 商品名,
dbo.SCM_BillDetail_SaleBill.QTy AS 数量, dbo.SCM_BillDetail_SaleBill.Price AS 单价, dbo.SCM_BillDetail_SaleBill.TotalMoney AS 金额,
dbo.SCM_BillDetail_SaleBill.Field2 AS 应扣税金, dbo.SCM_BillDetail_SaleBill.Field1 AS 维修基金
FROM dbo.Pub_Etype INNER JOIN
dbo.SCM_BillDetail_SaleBill ON dbo.Pub_Etype._id = dbo.SCM_BillDetail_SaleBill.EID INNER JOIN
dbo.Pub_Ptype ON dbo.SCM_BillDetail_SaleBill.PID = dbo.Pub_Ptype._id INNER JOIN
dbo.Pub_Btype ON dbo.SCM_BillDetail_SaleBill.BID = dbo.Pub_Btype._id
GROUP BY dbo.Pub_Etype.FullName, dbo.SCM_BillDetail_SaleBill.BillCode, dbo.SCM_BillDetail_SaleBill.BillDate, dbo.Pub_Btype.FullName,
dbo.Pub_Ptype.FullName, dbo.SCM_BillDetail_SaleBill.QTy, dbo.SCM_BillDetail_SaleBill.Price, dbo.SCM_BillDetail_SaleBill.TotalMoney,
dbo.SCM_BillDetail_SaleBill.Field2, dbo.SCM_BillDetail_SaleBill.Field1
ORDER BY 业务员, 往来单位, 单据编号, 日期, 商品名, 数量, 单价, 金额, 应扣税金, 维修基金
管家婆A8应用:统计5个自定义项目各类值。具体应用通讯行业、电脑行业等等,以此脚本定制其他各类销售明细查询。这只是一个小例子。
运行图如下:
|