更新各公司菜單名稱SQL

--Update Domain
UPDATE DB_YTZY.BAS.DOMAIN_INFO SET DOMAIN_NAME_CH=b.DOMAIN_NAME_CH,
DOMAIN_NAME_TH=b.DOMAIN_NAME_TH,DOMAIN_NAME_EN=b.DOMAIN_NAME_EN
FROM DB_YTZY.BAS.DOMAIN_INFO a,DB_ESON.BAS.DOMAIN_INFO b
WHERE a.DOMAIN_NO=b.DOMAIN_NO

--Update Package
UPDATE DB_YTZY.BAS.PACKAGE_INFO SET PACK_NAME_CH=b.PACK_NAME_CH,
PACK_NAME_TH=b.PACK_NAME_TH,PACK_NAME_EN=b.PACK_NAME_EN
FROM DB_YTZY.BAS.PACKAGE_INFO a,DB_ESON.BAS.PACKAGE_INFO b
WHERE a.PACK_NO=b.PACK_NO

--Update Program
UPDATE DB_YTZY.BAS.PROGRAM_INFO SET PRO_NAME_CH=b.PRO_NAME_CH,
PRO_NAME_TH=b.PRO_NAME_TH,PRO_NAME_EN=b.PRO_NAME_EN
FROM DB_YTZY.BAS.PROGRAM_INFO a,DB_ESON.BAS.PROGRAM_INFO b
WHERE a.PRO_NO=b.PRO_NO