多表联接批量更新
多表连接批量更新。UPDATE BOMT SET WASTAGE 0.00 WHERE CODE(SELECT A.CODE FROM BOMT A LEFTJOIN PR
多表连接批量更新。
UPDATE BOMT SET WASTAGE = '0.00' WHERE
CODE=(SELECT A.CODE FROM BOMT A LEFT JOIN PRO B ON A.CODE=B.CODE WHERE B.SERIES='D')
AND BOMNO=(SELECT A.BOMNO FROM BOMT A LEFT JOIN PRO B ON A.CODE=B.CODE WHERE B.SERIES='D')
[解决办法]UPDATE BOMT SET WASTAGE = '0.00' WHERE exists (select 1 FROM BOMT A LEFT JOIN PRO B ON A.CODE=B.CODE WHERE B.SERIES='D' and A.CODE=code and A.BOMNO=BOMNO)
[解决办法]update A set WASTAGE = '0.00' from BOMT A inner join PRO B ON A.CODE=B.CODE and WHERE B.SERIES='D'
[解决办法]- -多个and，更新用left join没有意义吧
update A set WASTAGE = '0.00' from BOMT A inner join PRO B ON A.CODE=B.CODE WHERE B.SERIES='D'
[解决办法]不知道你要实现什么结果，猜一个
update bomt set wastage='0.00' from bomt a join pro b
on a.code=b.code and b.series='d'
