update tsmdd57 a set (a.INVOICE_NO,a.INVOICE_CODE,a.TAX_PRICE,a.NO_TAX_PRICE,a.NO_TAX_AMOUNT,a.TAX_RATE,a.AMOUNT_TAX,a.TAX_AMOUNT,a.VOUCHER_NO,a.SALE_BILL_NO)
=(select b.INVOICE_NO,b.INVOICE_CODE,b.TAX_PRICE,b.NO_TAX_PRICE,b.NO_TAX_AMOUNT,b.TAX_RATE,b.AMOUNT_TAX,b.TAX_AMOUNT,b.VOUCHER_NO,b.SALE_BILL_NO from tsmdd56 b
where a.stacking_no=b.STACKING_NO)
where exists(select 1 from tsmdd56 b where a.stacking_no=b.STACKING_NO)
多表多字段关联更新
最新推荐文章于 2022-03-08 10:37:15 发布