Select A.fMaterielNo As fMaterielNo3/* 物料编号 */,A.fBarCode As fBarCode25/* 条码 */,A.fManSign As fManSign39/* 自定义标识码 */,A.fMaterielName As fMaterielName4/* 物料名称 */,A.ZJM As ZJM24/* 助记码 */,A.fForeignName As fForeignName6/* 外文名称 */,A.fMaterielSpec As fMaterielSpec5/* 物料规格 */,A.fBaseUnit As fBaseUnit17/* 基础单位 */,A.fPurchaseSprice As fPurchaseSprice19/* 标准进价 */,A.fLastTaxPrice As fLastTaxPrice46/* 最新进价 */,A.fSaleSprice As fSaleSprice18/* 标准售价 */,A.fBalance As fBalance0/* 售价与进价比 */,A.fMaterielID As fMaterielID1/* 物料ID */ From (select A.*,B.fTypeNo+' '+B.fTypeName as fTypeNoName,C.fPardNo+' '+C.fPardName as fPardNoName,(case when fLastTaxPrice<>0 then fSaleSprice/fLastTaxPrice else 0 end) as fBalancefrom PCode_Materiel as A left join PCode_MaterielType as B on A.fLineType=B.fTypeId left join OpPard_Pard as C on A.fProviderID=C.fPardID) As A /*查询.PCode_物料管理*/ Where 1=1and ((A.SignDelete IS NULL) or (A.SignDelete <> 1) )