UPDATE TBL_SLIP_PRODUCTWORK
SET N_INPUT_STATUS = (select 3 FROM TBL_SLIP_PRODUCTWORKSUB WHERE
TBL_SLIP_PRODUCTWORK.V_COMPANYID = 'COM00001'
AND TBL_SLIP_PRODUCTWORK.V_EMPID1 = TBL_SLIP_PRODUCTWORK.V_EMPID2
AND TBL_SLIP_PRODUCTWORKSUB.V_PRODUCT_CODE1 = TBL_SLIP_PRODUCTWORKSUB.V_PRODUCT_CODE2)
SET N_INPUT_STATUS = (select 3 FROM TBL_SLIP_PRODUCTWORKSUB WHERE
TBL_SLIP_PRODUCTWORK.V_COMPANYID = 'COM00001'
AND TBL_SLIP_PRODUCTWORK.V_EMPID1 = TBL_SLIP_PRODUCTWORK.V_EMPID2
AND TBL_SLIP_PRODUCTWORKSUB.V_PRODUCT_CODE1 = TBL_SLIP_PRODUCTWORKSUB.V_PRODUCT_CODE2)
SET N_INPUT_STATUS = 3
WHERE
TBL_SLIP_PRODUCTWORK.V_COMPANYID = 'COM00001'
AND TBL_SLIP_PRODUCTWORK.V_EMPID1 = TBL_SLIP_PRODUCTWORK.V_EMPID2
AND TBL_SLIP_PRODUCTWORKSUB.V_PRODUCT_CODE1 = TBL_SLIP_PRODUCTWORKSUB.V_PRODUCT_CODE2
如果没有,直接
update table1 set table1.yourcoloum=yourvalue where table1.a=table1.b不就可以了
where语句已经限定了要update哪些记录,和table2.a=table2.b又有什么关系?看不懂
题主的回答 :(