跳至主要內容

格搜:采购申请报表-目标价格等于该供应商最后一次报价价格

五六零网校小于 1 分钟

  • 示例代码
SELECT top 1 T1.[Price] FROM OPQT T0  INNER JOIN PQT1 T1 ON T0.[DocEntry] = T1.[DocEntry] 
where t0.cardcode=$[$1470000006.1470000007.0]   and t1.itemcode=$[$1470000006.1470000003] AND T0.[CANCELED]='N' AND T0.[DocStatus]='O'
ORDER BY T0.[DocNum] DESC