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.tkk7.com/szhswl
------------------------------------------------------------------------------------------------------ ----------------- ---------