update set from

update JL_SC_SM_SalesOrderDetail set JContractPrice = b.JTaxPrice,JContractAmount=b.JTaxAmount


from JL_SC_SM_SalesOrderDetail a , JL_SC_SMSalesContraEntry b
where a.JSrcBillDetailID=b.id

原文地址:https://www.cnblogs.com/YyuTtian/p/4414873.html