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?