sql1.txt

来自「这是一个啤酒行业的软件」· 文本 代码 · 共 6 行

INSERT INTO MYReport_New
      (Billcode, Data1)
SELECT a.BillCode, b.CheckData
FROM MYReport a INNER JOIN
      MYData b ON a.BillCode = b.BillCode
WHERE (a.BillCode = 'my080101001') AND (b.CheckName = '水份')