22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT
([物料表].[F_119]) AS [克重(g)], ([采购订单(视图)].[FMangerID]) AS [主管], ([采购订单(视图)].[FCheckerID]) AS [审核人],
([采购订单(视图)].[FBillerID]) AS [制单], ([采购订单(视图)].[FNote]) AS [备注], ([采购订单(视图)].[FCommitdate]) AS [交货日期],
([采购订单(视图)].[FAmount]) AS [金额], ([采购订单(视图)].[Fauxprice]) AS [单价],([采购订单(视图)].[FAuxQty]) AS [数量],
([采购订单(视图)].[FUnitGroupID]) AS [基本单位], ([采购订单(视图)].[Fmodel]) AS [规格型号], ([采购订单(视图)].[FItemID]) AS [物料名称],
([采购订单(视图)].[FNumber]) AS [物料代码], ([采购订单(视图)].[Fdate]) AS [日期], ([供应商档案].[FAddress]) AS [地址],
([供应商档案].[FFax]) AS [传真], ([供应商档案].[FPhone]) AS [电话], ([供应商档案].[FContact]) AS [联系人], ([采购订单表].[FHeadSelfP0254]) AS [付款条件],
([采购订单(视图)].[FBillNo]) AS [编号], ([采购订单(视图)].[FSupplyID]) AS [供应商],([结算方式表].[FName]) AS [结算方式名称],COUNT(*) as 哦女
FROM ((((([POOrder] AS [采购订单表] INNER JOIN [POOrderEntry] AS [采购订单分录表] ON [采购订单表].[FInterID]=[采购订单分录表].[FInterID]) INNER JOIN [t_ICItem] AS [物料表]
ON [采购订单分录表].[FItemID]=[物料表].[FItemID]) INNER JOIN [vwICBill_26] AS [采购订单(视图)] ON [采购订单表].[FInterID]=[采购订单(视图)].[FInterID]) INNER JOIN [t_Supplier] AS
[供应商档案] ON [采购订单表].[FSupplyID]=[供应商档案].[FItemID]) INNER JOIN [t_Settle] AS
[结算方式表] ON [采购订单表].[FSettleID]=[结算方式表].[FItemID]) where [采购订单分录表].[Fentryid]=[采购订单(视图)].[Fentryid] and ([采购订单(视图)].[FBillNo])='p170716539'
group by ([物料表].[F_119]),[采购订单(视图)].[FMangerID],[采购订单(视图)].[FCheckerID],[采购订单(视图)].[FBillerID],[采购订单(视图)].[FNote],[采购订单(视图)].[FCommitdate],
[采购订单(视图)].[FAmount],[采购订单(视图)].[Fauxprice],[采购订单(视图)].[FAuxQty],[采购订单(视图)].[FUnitGroupID],[采购订单(视图)].[Fmodel],[采购订单(视图)].[FItemID],
[采购订单(视图)].[FNumber],[采购订单(视图)].[Fdate],[供应商档案].[FAddress],[供应商档案].[FFax],[供应商档案].[FPhone],[供应商档案].[FContact],[采购订单表].[FHeadSelfP0254],
[采购订单(视图)].[FBillNo],[采购订单(视图)].[FSupplyID],[结算方式表].[FName]