用B表更新A表

UPDATE dbo.POR_LOT SET POR_LOT.SHIPPED_FLAG =B.SHIPPED_FLAG
FROM POR_LOT A INNER JOIN ( SELECT T5.LOT_NUMBER,(CASE WHEN t3.TYPE =‘生产出库‘ THEN 0 WHEN T3.TYPE=‘销售出库‘ THEN 1 end) SHIPPED_FLAG
FROM WMS_STORAGE_OUT_DETAIL T2
INNER JOIN WMS_STORAGE_OUT T3 ON T2.ORDER_ID = T3.ORDER_ID
INNER JOIN dbo.WIP_CONSIGNMENT T4 ON T2.PALLET_NO=T4.PALLET_NO
INNER JOIN dbo.WIP_CONSIGNMENT_DETAIL T5 ON T4.PALLET_NO=T5.PALLET_NO
WHERE T3.ORDER_NUMBER = ‘O002‘
) B ON B.LOT_NUMBER=A.LOT_NUMBER

用B表更新A表

原文：http://www.cnblogs.com/ChineseMoonGod/p/6479756.html