Running a select returns:
Server: Msg 446, Level 16, State 9, Line 1
Cannot resolve collation conflict for equal to operation.

I'm only joining 2 tables with a column (no_dept) that is varchar(20) on both tables.

Any clues ?