0
0
0
0
Read Time35 Second
I have two data bases: db_A and db_B.
I’m trying to join one table from db_A with another table of db_B. Both of this tables have a column in common, id_card. So I’m trying something like this:
SELECT *
FROM db_A.table_1
LEFT JOIN db_B.table_2
ON db_A.table_1.id_card = db_B.table_2.id_card
;
But when I run this code in SQL Server I get this error:
Msg 468, Level 16, State 9, Line 76 Cannot resolve the collation conflict between “Modern_Spanish_CI_AS” and “Latin1_General_CI_AI” in the equal to operation.
Is there any way to solve this problem?
Thanks.