金蝶,三表联查"/>
金蝶,三表联查
SELECT
a.FBillNo 单据编号, a.FDate 单据日期, c.FName 物料名称, a.FText3 源单编号,a.FText1 摘要,
b.FQty 数量,b.FPrice1 单价,b.FPrice 含税单价,b.F_JX_YuJiDate 预计询价日期,b.F_JX_ShiJiDate 实际询价日期,
b.F_JX_Provider 供应商,b.FDate3 货期,case when b.F_JX_YuJiDate<b.F_JX_ShiJiDate then ‘是’ else ‘否’ end 及时率,
b.FDate4 预计报价日期,e.[完成率%]
FROM t_BOSXunJia a join t_BOSXunJiaEntry b
on a.FID =b.FID
join t_ICItem c
on c.FItemID = b.FBase1
left join (select
convert(float,max(d.完成数量))/convert(float,count(FPrice))*100 “完成率%”,FBillNo 单据编码
FROM t_BOSXunJia a join t_BOSXunJiaEntry b
on a.FID =b.FID
inner join (SELECT COUNT(FPrice)完成数量,fbillno 单据编号 FROM t_BOSXunJia a join t_BOSXunJiaEntry b
on a.FID =b.FID
where FPrice > 0
group by FBillNo)d
on d.单据编号 = a.FBillNo
group by FBillNo)e
on e.单据编码 = a.FBillNo
更多推荐
金蝶,三表联查
发布评论