select * from (
select
s1.fbillno as 订单编号,
s2.fentryid as 订单行号,
t.fnumber as 物料长代码,
t.FName as 物料名称,
t.FModel as 规格型号,
s2.FQty as 订单数量,
i2.FQty as 入库数量,
s2.FDate as 出货日期,
i1.fdate as 实际入库日期,
i1.fbillno as 出库单号,
datediff("D",s2.FDate,i1.fdate) as 相差天数
from SEOrderEntry s2
join SEOrder s1 on s1.FInterID=s2.FInterID
join t_ICItem t on s2.FItemID=t.fitemid
join ICMO m on m.FOrderInterID=s2.FInterID and m.FSourceEntryID=s2.FEntryID
join ICStockBillEntry i2 on m.FInterID=i2.FSourceInterId and s2.FItemID=i2.FItemID
join ICStockBill i1 on i1.FInterID=i2.FInterID
where
(s2.FDate>='2013-10-1'and s2.FDate<='2013-10-31')and
(t.FNumber>='07.01.01.001'and t.FNumber<='07.01.99.999')and
i1.ftrantype='2'and
s1.FCancellation='0'
union all
select
null as 订单编号,
null as 订单行号,
null as 物料长代码,
'订单及时率' as 物料名称,
null as 规格型号,
null as 订单数量,
null as 入库数量,
null as 出货日期,
null as 实际入库日期,
null as 出库单号,
count(*)/(count(datediff("D",s2.FDate,i1.fdate))> -1) as 相差天数
from SEOrderEntry s2
join SEOrder s1 on s1.FInterID=s2.FInterID
join t_ICItem t on s2.FItemID=t.fitemid
join ICMO m on m.FOrderInterID=s2.FInterID and m.FSourceEntryID=s2.FEntryID
join ICStockBillEntry i2 on m.FInterID=i2.FSourceInterId and s2.FItemID=i2.FItemID
join ICStockBill i1 on i1.FInterID=i2.FInterID
where
(s2.FDate>='2013-10-1'and s2.FDate<='2013-10-31')and
(t.FNumber>='07.01.01.001'and t.FNumber<='07.01.99.999')and
i1.ftrantype='2'and
s1.FCancellation='0'
) v
order by 订单编号,物料长代码
----------------------------------------------------
执行的时候提示错误：
消息 102，级别 15，状态 1，第 38 行
“>”附近有语法错误。
count这函数的用法错了吗？提示错误的是这里(count(datediff("D",s2.FDate,i1.fdate))> -1)，没弄明白，非常感谢，请帮看看。
------解决方案--------------------
记得结贴
