什么国外游戏直播软件:各位高手,有谁会SQL语句的帮一下忙

来源:百度文库 编辑:杭州交通信息网 时间:2024/04/30 01:54:39
以下是什么意思啊!!
Date:2005-12-22 author:licb */

select com_item.fname,sum(famttotal) 总金额--,sum(fqty) 数量
from com_invsaleentry,t_item,(select com_item.fitemid,f_117,fsystypeid,fname
from com_item,com_systype
where fsystypeid=f_117)com_item,com_invsale,t_organization,t_department
where com_item.fitemid=com_invsaleentry.fitemid
--and com_invsale.fpreparerid =t_user.fuserid
and t_organization.fitemid=com_invsale.fcustomerid
and t_item.fitemid=com_item.fitemid
and com_invsale.fid=com_invsaleentry.fid
and t_department.fitemid=com_invsale.fdeptid
and com_invsale.fperiod between 11 and 11 --更改月份
and fcheckerid<>0 --表示单据已审核0为未审核
and t_organization.fnumber not like '90.%'
and t_organization.fnumber not like '97.%'
and t_organization.fnumber not like '98.%'
--and t_item.fname like '%赣玛%' --按名称查询销售
--and substring(t_department.fname,0,3)='成寿'
--and t_item.fnumber like '04.02.02.577538' --按代码查询销售
--having substring(t_department.fname,0,3)
group by com_item.fname--com_invsale.fperiod,t_item.fnumber,t_item.fname,com_item.fmodel

汇总