SELECT JHXX.产品批号, SPMX.产品名称, JHXX.物资编码, JHXX.材料名称, JHXX.材质型号,
JHXX.规格, SUM(JHXX.定额 * JHXX.单台数量 * SPMX.台数) AS 定额, JHXX.单位,
JHXX.业务人员FROM JHXX INNER JOIN
SPMX ON JHXX.产品批号 = SPMX.产品批号WHERE JHXX.产品批号 (NOT in
(SELECT JHXX.产品批号
FROM CLXX
WHERE CLXX.产品批号 = jhxx.产品批号 AND clxx.物资编码 = ...
|