【SQL】解決不同DB定序問題, not in, not exists

Ex: 存在於不同 簡繁體DB

    Chinese_PRC_CI_AS (簡體)
    Chinese_Taiwan_Stroke_CI_AS (繁體)

   SELECT Table1.*,Table2.*
　 FROM Table1
　 INNER JOIN Table2 ON Table2.FK = Table1.PK COLLATE Chinese_PRC_CI_AS

    SELECT Table1.*,Table2.*
　　FROM Table1
　　INNER JOIN Table2 ON Table2.FK = Table1.PK COLLATE Chinese_Taiwan_Stroke_CI_AS 

not in 用法 :

select T0.ItemCode
from RDC090123.dbo.OITM T0
where T0.frozenFor='Y' and
T0.ItemCode not in ( select distinct X.CN_CODE COLLATE Chinese_Taiwan_Stroke_CI_AS  from EMasterPDM.dbo.TN_NODE X
where T0.ItemCode=X.CN_CODE COLLATE Chinese_Taiwan_Stroke_CI_AS )

not EXISTS用法 :

select T0.ItemCode
from RDC090123.dbo.OITM T0
where T0.frozenFor='Y' and
not EXISTS  ( select distinct X.CN_CODE COLLATE Chinese_Taiwan_Stroke_CI_AS  from EMasterPDM.dbo.TN_NODE X 
where T0.ItemCode=X.CN_CODE COLLATE Chinese_Taiwan_Stroke_CI_AS)
 
以上兩個結果都一樣