UPDATE PUBLIC.CMS_DOCUMENT A SET A.XPUBLISHTIME = A.XUPDATETIME , 
A.XCATAGORYNAME = ( SELECT XCATAGORYNAME FROM PUBLIC.CMS_CATAGORYINFO WHERE XID= A.XCATAGORYID )