update SBD_RETURN_BILL set RB_IS_CONFIRM=1,RB_CONFIRM_DATE=@RB_CONFIRM_DATE,RB_CONFIRM_ORG=@RB_CONFIRM_ORG,RB_CONFIRM_ID=@RB_CONFIRM_ID,RB_SIGN_DATE=(select SW_CREATE_DATE from SBD_WAYBILL where SW_ID=RB_SB_ID)
原文：http://www.cnblogs.com/sunxi/p/4251254.html