kingdee中的sql查询数据不能出来

来源：百度知道 编辑：UC知道 时间：2024/06/10 20:09:12
我想看到采购流程的走向，朋友帮我变了一个，可是不能出数据，不知道是什么原因。
select t0.fdate as 申购日期,t0.fbillno as 申购单号,t3.fnumber as 物料代码,t3.fname as 物料名称,t1.OrderBillno as 订单编号,t1.OrderQty as 订单数量,t1.InBillNo as 入库单号,t1.inQty as 入库数量 FROM
(select t0.fdate,t0.fbillno,t0.finterid,t1.fitemid,sum(t1.fqty) as RequestQty from PORequest t0 inner join PORequestentry t1 on t0.finterid=t1.finterid
group by t0.fdate,t0.fbillno,t0.finterid,t1.fitemid) t0

left join (
select t0.fbillno as OrderBillno,t0.fsourceinterid,t0.fitemid,t0.OrderQty,t1.fbillno as InBillNo,t1.inQty from (
select t0.fbillno,t0.finterid,t1.fsourceinterid,t1.fitemid,sum(t1.fqty) as OrderQty
from POOrder t0 inner join POOrderentry t1 on t0.finterid=t1.finterid and t1.FSourceTranType=70
group by t0.fbillno,t0.finterid,t1.fsourceinterid,t1.fitemid
) t0
left join (
select t0.fbillno,t1.fsourceinterid,t1.fitemid,sum(t1.fqty) as inQty
from icstockbill t0 inner join icstockbillentry t1 on t0.fi

把'%*FBillNoCommon*%' 改成'%'+'*FBillNoCommon*'+'%'就可以了，我刚接触的时候也搞了好久，你试试看吧

我把你的SQL语句放到我的机器上执行，可以出来结果。
你把条件都去掉看能不能得出结果来，另外就是你需要增加一个名为*FBillNoCommon*的关键字，注意区分大小写。