下面的语句怎么才能让company有效

select * from （SELECT SaleBillVouch.cSBVCode as 单据号, SaleBillVouch.dDate AS 销售日期,SaleBillVouch.cCusName AS 客户, SaleBillVouchs.cInvCode AS 存货编码, Inventory.cInvName AS 存货名称,inventory.cInvStd as 规格型号,

SaleBillVouchs.iQuantity AS 数量,SaleBillVouchs.iNum AS 件数, salebillvouchs.iTaxUnitPrice as 含税单价,salebillvouchs.isum as 销售金额,

IA_Subsidiary.iAOutPrice as 成本金额

FROM SaleBillVouch with(nolock)

inner JOIN SaleBillVouchs with(nolock) ON SaleBillVouchs.SBVID = SaleBillVouch.SBVID

inner JOIN Customer with (nolock) ON SaleBillVouch.cCusCode = Customer.cCusCode

inner JOIN Inventory with (nolock) ON SaleBillVouchs.cInvCode = Inventory.cInvCode

inner join IA_Subsidiary with (nolock) ON salebillvouchs.idlsid = IA_Subsidiary .idlsid and salebillvouchs.cInvCode = IA_Subsidiary.cInvCode

where YEAR(salebillvouch.dDate )>=(2019) order by 销售日期） where SaleBillVouch.cCusName = "${company}" and SaleBillVouch.cCusName=SaleBillVouch.cSBVCode

FineReport lhq5600182 发布于 2020-5-28 15:00

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共4回答

最佳回答

zsh331Lv8专家互助
发布于2020-5-28 15:08

SELECT *
FROM (
SELECT 
SaleBillVouch.cSBVCode AS 单据号
,SaleBillVouch.dDate AS 销售日期
,SaleBillVouch.cCusName AS 客户
,SaleBillVouchs.cInvCode AS 存货编码
,Inventory.cInvName AS 存货名称
,inventory.cInvStd AS 规格型号
,SaleBillVouchs.iQuantity AS 数量
,SaleBillVouchs.iNum AS 件数
,salebillvouchs.iTaxUnitPrice AS 含税单价
,salebillvouchs.isum AS 销售金额
,IA_Subsidiary.iAOutPrice AS 成本金额
FROM SaleBillVouch
INNER  JOIN SaleBillVouchs  ON SaleBillVouchs.SBVID = SaleBillVouch.SBVID
INNER  JOIN Customer  ON SaleBillVouch.cCusCode = Customer.cCusCode
INNER  JOIN Inventory ON SaleBillVouchs.cInvCode = Inventory.cInvCode
INNER JOIN IA_Subsidiary ON salebillvouchs.idlsid = IA_Subsidiary .idlsid
AND salebillvouchs.cInvCode = IA_Subsidiary.cInvCode
WHERE YEAR(salebillvouch.dDate) >= 2019 AND SaleBillVouch.cCusName = SaleBillVouch.cSBVCode
-- ORDER BY 销售日期
) t
WHERE t.客户 = "${company}"

举报收起评论(4)

lhq5600182(提问者) 运行了。不对

2020-05-28 16:54

zsh331 回复 lhq5600182(提问者) 不对是几个意思？

2020-05-28 16:55

lhq5600182(提问者) 回复 zsh331 建立数据集，提示错误。com.fr.general.data.tabledataexception:错误代码:11300001 数据配置错误 Query: 除非另外还指派了 TOP、OFFSET或FOR XML，否则，ORDER BY 字句在视图、内联函数、派生表、字查询和公用表表达式中无效。

2020-05-28 17:32