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

posted @ 2015-04-10 15:54  YyuTtian  阅读(99)  评论(0编辑  收藏  举报