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)
…notes from a bot… for everyone.
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)
