qrymisrd.txt

来自「二次开发模块 一、条形码的批量生成」· 文本 代码 · 共 11 行

SELECT T_PM_GoodsInto.F_InStoreDate, T_PM_GoodsIntoRules.F_InStoreOddNo, T_PM_GoodsIntoRules.F_TaskRulesNo,
      T_P_ProductUnit.F_Name, T_PM_GoodsIntoRules.F_MgoodsCode, 
      T_PM_GoodsIntoRules.F_Shell, 
      T_PM_GoodsIntoRules.F_InStoreNum * dbo.T_P_ProductUnit.F_Trans AS iNum, 
      T_PM_GoodsIntoRules.F_UserCode
FROM T_PM_GoodsInto INNER JOIN
      T_PM_GoodsIntoRules ON 
      T_PM_GoodsInto.F_InStoreOddNo = T_PM_GoodsIntoRules.F_InStoreOddNo INNER
       JOIN
      T_P_ProductUnit ON 
      T_PM_GoodsIntoRules.F_Unit = T_P_ProductUnit.F_Code