編碼不同時的資料關聯

select ima01,ima02,ima021,ima04,ima06,ima08,ima15,ima43,ima48,ima49,ima67,ima76  from openquery(KSTiptop,'select ima01,ima02,ima021,ima04,ima06,ima08,ima15,ima43,ima48,ima49,ima67,ima76 from ima_file') a where a.ima01 COLLATE Chinese_PRC_CI_AS  not in(select ima01 from mrp.ima_file);update mrp.ima_file set ima02=b.ima02,ima021=b.ima021           ,ima04=b.ima04,ima06=b.ima06,ima08=b.ima08           ,ima15=b.ima15,ima43=b.ima43,ima48=b.ima48           ,ima49=b.ima49,ima67=b.ima67,ima76=b.ima76     from mrp.ima_file a,openquery(KSTiptop,'select ima01,ima02,ima021,ima04,ima06,ima08,ima15,ima43,ima48,ima49,ima67,ima76 from ima_file') b where a.ima01 COLLATE Chinese_PRC_CI_AS=b.ima01;