update JL_SC_SM_SalesOrderDetail set JContractPrice = b.JTaxPrice,JContractAmount=b.JTaxAmount
from JL_SC_SM_SalesOrderDetail a , JL_SC_SMSalesContraEntry bwhere a.JSrcBillDetailID=b.id
update set from
原文：http://www.cnblogs.com/YyuTtian/p/4414873.html
