I had the same problem, I couldn't change the collation and I've learned to do

select * from tableA join tableB on tableA.fieldA collate [....] = tableB.fieldB

or

select * from tableA where fieldA in (Select fieldB collate [....] from tableB)

I hope this helps!