sql直接帐表报错

云社区用户RO579973

995次浏览编辑于2015年04月12日 11:38:43

select T3.FNUMBER as 物料编码,sum(t1.FREALQTY) as 出库数量,sum(t2.FCOSTAMOUNT)/sum(t1.FREALQTY) as 单位成本,sum(t2.FCOSTAMOUNT)/sum(t1.FREALQTY)*1.17 as 含税成本, sum(t2.FCOSTAMOUNT) as 销售成本,
SUM(T5.FPRICEQTY) AS 销售数量,SUM(t5.FNOTAXAMOUNTFOR)/SUM(T5.FPRICEQTY) as 销售单价,SUM(t5.FNOTAXAMOUNTFOR)/SUM(T5.FPRICEQTY)*1.17 as 含税单价,SUM(t5.FNOTAXAMOUNTFOR) AS 销售收入,(SUM(t5.FNOTAXAMOUNTFOR)-sum(t2.FCOSTAMOUNT)) as 销售利润,(SUM(t5.FNOTAXAMOUNTFOR)-sum(t2.FCOSTAMOUNT))/SUM(t5.FNOTAXAMOUNTFOR) as 毛利润率
from T_SAL_OUTSTOCKENTRY t1

直接sql帐表不支持黑色加粗字体吗？现在写的直接sql帐表，只要带这样的语句的就报错。
希望老师能给个变通的方法；qq：1982192062

赞 0 评论 2 收藏

sql直接帐表报错

恭喜您！