UPDATE SA.SUBMIT SA
   SET SEND_STATE = (SELECT SEND_STATE
                       FROM PHS.SUBMIT
                      WHERE PHS.SUBMIT.ID = SA.ID
                        AND SUBSTR(SA.SEND_STATE, 15, 1) <>
                            AN.SUBMIT.SEND_STATE
                        AND SUBSTR(SA.SEND_STATE, 15, 1) IS NOT NULL)
 WHERE SA.ISCHGSTATUS = 0 AND EXISTS
 (SELECT 1
          FROM PHS.SUBMIT PHS
         WHERE PHS.ID = SA.ID
           AND SUBSTR(SA.SEND_STATE, 15, 1) <> PHS.SEND_STATE
           AND SUBSTR(SA.SEND_STATE, 15, 1) IS NOT NULL)

SQL说明：更新sa用户的submit表，与an用户的submit表相同字段但值不相同的数据。

---------------------------------------------------------------------------------------------------------------------------------
说人之短，乃护己之短。夸己之长，乃忌人之长。皆由存心不厚，识量太狭耳。能去此弊，可以进德，可以远怨。
http://www.blogjava.net/szhswl
------------------------------------------------------------------------------------------------------ ----------------- ---------