原物料报检表tblsignin
原物料出入库表 tblStockMtrlmng
出入库表中共有五条数据 ,LEFT JOIN后,出现了重复数据。同样的语句别的产品都没有问题,单独产品140301026批号100416出现问题。很奇怪
语句如下:
SELECT a.fdCodeNo, ISNULL(a.fdpihao, 0) AS pihao, a.fdRealReceiveNum AS ruku,
a.fdRealWithDrawNum AS tuiku, a.fdFakeWithDrawNum AS Expr2
FROM tblStockMtrlmng a LEFT OUTER JOIN
tblsignin ON a.fdCodeNo = tblsignin.fdproid AND
a.fdpihao = tblsignin.fdstocknum
WHERE (a.fdCodeNo = '140301026') AND (a.fdpihao = 100416)
执行界面截图:
