<filename>x_cms_assemble_control/update/SQL_2017-01-15_135200.sql
UPDATE PUBLIC.CMS_DOCUMENT A SET A.XPUBLISHTIME = A.XUPDATETIME , 
A.XCATAGORYNAME = ( SELECT XCATAGORYNAME FROM PUBLIC.CMS_CATAGORYINFO WHERE XID= A.XCATAGORYID )