update 问题
update w1
set BaseFlowNo=( isnull((
select min(p.BaseFlowNo) from ProductWorkFlow p,WorkBill_Flow w
where p.productNo=w.ProductNo and p.workBillTypeNo=w.BillTypeNo and w.workbillNo='CK1003KJXA840930'
and p.BaseFlowNo>'06' group by w.BaseFlowNo),'06')),
BaseFlowName=b.FlowName from WorkBill_Flow w1,BaseFlow b
where w1.BaseFlowNo=b.FlowNo and WorkBillNo='CK1003KJXA840930'
这个语句,第一次执行 把 set BaseFlowNo 这个字段更新了,但是没有更新BaseFlowName=b.FlowName 为什么