SQL Joins tables different collations databases

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)

Rispondi