select field collate Latin1_General_100_CI_AS
from table_1
inner join table_2
on (table_1.field collate Latin1_General_100_CI_AS = table_2.field)
SQL Joins tables different collations databases
Lascia una risposta
select field collate Latin1_General_100_CI_AS
from table_1
inner join table_2
on (table_1.field collate Latin1_General_100_CI_AS = table_2.field)